Can't add a 0 (zero) to the beginning of a number in a cell

[Scottrow]

I am trying to put a serial number in a cell but it starts with a zero.
After I type in 09867453 and move to the next cell the 0 disappears.

Scott

 

[brauer.greg]

You can format the cell to be text and it will then allow a 0 to be
added to the front of a number however this may cause problems if you
are using that number in inequalities.

 

[PMC527]

Scott,

The first answer is correct however it may be alot easier if you add an
apostrophe ' before the number. It won't show it is excel's way of
letting you start cells with a 0.

 

[Don Guillett]

another way is to format>cutom format>00000000000 as many as you like to 15

 

[Opinicus]

another way is to format>cutom format>00000000000 as many as you like to
15

That's the one I like because it data is still a number and can be
manipulated as such.

 

[Don Guillett]

glad to help