Home |
Search |
Today's Posts |
#1
|
|||
|
|||
zero value
How do you add a zero in front of a number in excel without it disappearing?
|
#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" wrote in message ... How do you add a zero in front of a number in excel without it disappearing? |
#3
|
|||
|
|||
-----Original Message----- How do you add a zero in front of a number in excel without it disappearing? . 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|