C CDPalmer Sep 11, 2009 #1 I have a column of 5 digit numbers which I would like to replace with the same number with a leading zero.
I have a column of 5 digit numbers which I would like to replace with the same number with a leading zero.
F Fred Smith Sep 11, 2009 #3 If you want to *display* the leading zero, use a custom format of 000000 (that's 6 zeros) If you want the leading zero stored in the spreadsheet, convert your numbers to text using: =text(a1,"000000") Regards, Fred.
If you want to *display* the leading zero, use a custom format of 000000 (that's 6 zeros) If you want the leading zero stored in the spreadsheet, convert your numbers to text using: =text(a1,"000000") Regards, Fred.
