If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
#5
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|