How do you add a zero in front of a number in excel without it disappearing?
P Peo Sjoblom Feb 11, 2005 #2 Precede it with an apostrophe or use a custom format like 0000 which would display 0123 if you enter 123 in the cell -- Regards, Peo Sjoblom Jimmy said: How do you add a zero in front of a number in excel without it Click to expand... disappearing?
Precede it with an apostrophe or use a custom format like 0000 which would display 0123 if you enter 123 in the cell -- Regards, Peo Sjoblom Jimmy said: How do you add a zero in front of a number in excel without it Click to expand... disappearing?
L Larry Harman Feb 11, 2005 #3 -----Original Message----- How do you add a zero in front of a number in excel without it disappearing? . Click to expand... if the number remains constant ie: 4 digits 1234 you want 01234 Format cell custom 00000 Email me and ill send back an xls to show you. Larry Harman
-----Original Message----- How do you add a zero in front of a number in excel without it disappearing? . Click to expand... if the number remains constant ie: 4 digits 1234 you want 01234 Format cell custom 00000 Email me and ill send back an xls to show you. Larry Harman
