zero value
 

How do you add a zero in front of a number in excel without it 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" wrote in message
...
How do you add a zero in front of a number in excel without it
disappearing?

-----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