Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want to display the number 0 first in a cell, it won't let me n.
I want to be able to see a number with a zero in front of it as in 019, no
decimals or anything but everytime I enter it and move to the next cell the 0 automatically disappears. Can anyone help? |
#2
|
|||
|
|||
Lauren -
You'll have to format the cell as "Text" to make it work. Hope this helps, Carole O "lauren" wrote: I want to be able to see a number with a zero in front of it as in 019, no decimals or anything but everytime I enter it and move to the next cell the 0 automatically disappears. Can anyone help? |
#3
|
|||
|
|||
Or, you can precede your value with a single quote...
'019 Hope this helps! In article , lauren wrote: I want to be able to see a number with a zero in front of it as in 019, no decimals or anything but everytime I enter it and move to the next cell the 0 automatically disappears. Can anyone help? |
#4
|
|||
|
|||
Right click on the cell, choose the "Number" tab. Within
the category field, choose text. That should help -----Original Message----- I want to be able to see a number with a zero in front of it as in 019, no decimals or anything but everytime I enter it and move to the next cell the 0 automatically disappears. Can anyone help? . |
#5
|
|||
|
|||
Lauren
In addition to the other posts..... Enter 19 and Custom Format as 000.\ It will look like 019 but still be the number 19 if you need it for calculations. Gord Dibben Excel MVP On Tue, 8 Mar 2005 11:23:10 -0800, lauren wrote: I want to be able to see a number with a zero in front of it as in 019, no decimals or anything but everytime I enter it and move to the next cell the 0 automatically disappears. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
Excel should let me circle a cell or number in the spreadsheet fo. | Excel Discussion (Misc queries) | |||
How do I display an insignificant 0 at the beginning of a number | Excel Discussion (Misc queries) | |||
insert a page number into a cell? | Excel Worksheet Functions | |||
cell that accepts a whole number or five place deciaml | Excel Worksheet Functions |