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

S

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
 
B

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

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

Opinicus

Don Guillett said:
another way is to format>cutom format>00000000000 as many as you like to
15
Click to expand...

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