Displaying "0" Values
 

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!

Displaying "0" Values
 

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!

Displaying "0" Values
 

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!*


"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!

Displaying "0" Values
 

Very, very helpful. Thank you so much

"Luke M" wrote:

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!*


"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!

Displaying "0" Values
 

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

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!