Displaying "0" Values

[Ant]

I am trying to type a series of numbers with "0"s. ex. 000058745. When I do
this excel kicks out all of the zeros. 58745. I need the zeroes to be
displayed in the cells. Also when I went to excel help, it shows you how to
do it and when I tried it, it did not work. Please help!

 

[Sheeloo]

If you are ok with treating them as text then enter a ' before entering the
numbers.

Since in a number 0s at the left don't mean anything Excel strips them off...

You can show zeros by formatting the cells as 000000
It will show 123 as 000123
but 0123456 as 123456

 

[Luke M]

Format cell, number tab, custom format
000000000

Or, if you don't mind treating the number as text, you can input into the
cell:
'000058745

And the apostrophe will tell XL to display exactly what you input.

 

[Ant]

Very, very helpful. Thank you so much

Format cell, number tab, custom format
000000000

Or, if you don't mind treating the number as text, you can input into the
cell:
'000058745

And the apostrophe will tell XL to display exactly what you input.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

 

[David Biddulph]

Tell us what you tried and in which way it didn't work.