| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show a zero?
I have numbers in a spredhseet that represent gift certificate numbers. They
all start with zeros, but the zxero disappears when I enter the value. How can I make sure the zero is represented for that cell. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I show a zero?
Linds wrote: I have numbers in a spredhseet that represent gift certificate numbers. They all start with zeros, but the zxero disappears when I enter the value. How can I make sure the zero is represented for that cell. Thanks! Hi Linds Either Format your cells as Text and re-enter the data (select the cells, press F2 and press Enter) or Apply a Custom format of 00000 (as many zeros as your numbers are long) or When entering the numbers start the entry with an apostrophe ('). Regards Steve |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I show a zero?
Have it enterered like '001. Inlcude the first character '
"Linds" wrote: I have numbers in a spredhseet that represent gift certificate numbers. They all start with zeros, but the zxero disappears when I enter the value. How can I make sure the zero is represented for that cell. Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I show a zero?
Hi Linds. Put an apostrophe ' in front of the number to make it text, as you
enter it. HTH -- Sincerely, Michael Colvin "Linds" wrote: I have numbers in a spredhseet that represent gift certificate numbers. They all start with zeros, but the zxero disappears when I enter the value. How can I make sure the zero is represented for that cell. Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I show a zero?
Pre-format the cells as text before entering.
Precede each number with an apostrophe. Format as Custom 0000000 or whatever number of 0's you need to have one at beginning. Any one of the above should do the job. Gord Dibben MS Excel MVP On Fri, 4 Aug 2006 15:16:03 -0700, Linds wrote: I have numbers in a spredhseet that represent gift certificate numbers. They all start with zeros, but the zxero disappears when I enter the value. How can I make sure the zero is represented for that cell. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show data used and percent label | Charts and Charting in Excel | |||
| leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
| Show values from other sheet | Excel Worksheet Functions | |||
| with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) | |||
| show macro security setting in a cell | Excel Worksheet Functions | |||
Hybrid Mode
