G
Guest
How would I update a column with numeric values so that there are 3 leading
zeros for each row?
zeros for each row?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
hi
it is not possible to add leading zeros to a numeric value. Mathematically,
this is redundent and unnecessary.
it is not possible to add leading zeros to a numeric value. Mathematically,
this is redundent and unnecessary.
G
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
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
D
Don Guillett
for each c in range("a2:a200")
c.value="000"& c
next c
c.value="000"& c
next c
G
Guest
hi,
format range A2:a200 to text first.
does works better that the concatinate formula. alot quicker. less mouse work.
regards
FSt1
format range A2:a200 to text first.
does works better that the concatinate formula. alot quicker. less mouse work.
regards
FSt1