| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering Numbers in a Cell
When I type a number in a cell with the first digit "0" the zero disappears.
How can I make it stay? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering Numbers in a Cell
If I format a cell with custom format of 00000
and enter 123, the cell displays 00123 Alternatively, if these are not really numbers (i.e you will not be going any arithmetic on them) then precede them with an apostrophe - it will not display in the cell nor will it print. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Tawn Tawn" <Tawn wrote in message ... When I type a number in a cell with the first digit "0" the zero disappears. How can I make it stay? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering Numbers in a Cell
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
| Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
Linear Mode
