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
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Ant" wrote:

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!