How to add leading zero's
 

I have a spreadsheet that I need to convert one column from a 5 decimal value
(1.23210) to 000000000123210. I need the cell to autofill up so that there
always 15 digits.

I can multiply the cell by 100,000 to remove the decimal but I can't figure
out how to have it automatically fill the cell to 15 digits.

Help

How to add leading zero's
 

=TEXT(A1*10000,"000000000000000")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Linda" wrote in message
...
I have a spreadsheet that I need to convert one column from a 5 decimal
value
(1.23210) to 000000000123210. I need the cell to autofill up so that
there
always 15 digits.

I can multiply the cell by 100,000 to remove the decimal but I can't
figure
out how to have it automatically fill the cell to 15 digits.

Help