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
|