How do I show zeros?

G

Guest

I need to show some numbered codes on my spreadsheet. But everytime I type
the codes with zeros in the beginning Excel deletes the zeros. So...

0051200
ends up being
51200

How do I stop this?
 
G

Gord Dibben

One of these three methods...............

Pre-format the cells as Text.

Type and apostrophe then your number.

Custom Format as 0000000


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add Leading Zeros 4
How do I make zeros show up with a diagonal line across them? 2
Find/Replace changes cell format ?????? 2
Show Zeros in some cells even though worksheet set to not show zer 6
How can I display numbers beginning with zero? 4
If number in cell does not equal 6 digits, add zeros to the left 2
How do I stop Excel from dropping leading zeros? 9
when i megre cells that begin with zeros , I lose the zeros 1

Top