Changing a column's number of decimal places

  • Thread starter Thread starter Shaun Allan
  • Start date Start date
S

Shaun Allan

I want to change a specific column's number of decimal
places to 1. How can I do this simply from within code?
Do I have to select the column first, then apply the code
or can I change the column without selecting it first?
 
As simple as that! Amazing! Thank you!!
-----Original Message-----
Hi
one way:
columns(1).numberformat="0.0"

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Import multiple workbooks to current workbook in specified row number 0
VBA set thick borders around non empty cells in range 0
Excel Number Formatting 1
Retain decimal places in a concatenate function 2
Copying a formula to a range 2
from pivot table to vb array copy to new table 3
Multiple maximums in column 3

Back
Top