View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LINDA LINDA is offline
external usenet poster
 
Posts: 205
Default 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