| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show zeros?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I show zeros?
nevermind I figured it out.
"J.D." wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I show zeros?
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 On Tue, 20 Mar 2007 09:22:34 -0700, J.D. wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot tables show zeros | Excel Discussion (Misc queries) | |||
| How do I make zeros show up with a diagonal line across them? | Excel Discussion (Misc queries) | |||
| In Excel how do I get 2 zeros to show automatically after I enter. | Excel Discussion (Misc queries) | |||
| How do I get the zeros to show up in the beginning of a number? | Excel Discussion (Misc queries) | |||
| Lead Zeros to Show? | Excel Worksheet Functions | |||
Linear Mode
