update column

[Guest]

How would I update a column with numeric values so that there are 3 leading
zeros for each row?

 

[Guest]

hi
it is not possible to add leading zeros to a numeric value. Mathematically,
this is redundent and unnecessary.

 

[Guest]

opps.
hit the post button too quick.
option 1. custom format
if your numeric value is 12345 then see the custom format to 00000000.
note. format do not change data - it just changes the way it looks in the
cell.
option2. format to text
then use the concatinate function to add the leading zeros.
your numeric values would not longer be numeric values but treated as text
by excel.

regards
FSt1

 

[Don Guillett]

for each c in range("a2:a200")
c.value="000"& c
next c

 

[Guest]

hi,
format range A2:a200 to text first.
does works better that the concatinate formula. alot quicker. less mouse work.

regards
FSt1