Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with entering cell number
When entering a cell number into one of the cells in xcell it throws the zero
away. What do I do to fix this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with entering cell number
Hi
Excel does not retain leading zeros with numbers. You will need to enter it as text. Either, preformat the cells as Text, or, insert a single quote in front of the number as you enter it '012345 -- Regards Roger Govier "Magda" wrote in message ... When entering a cell number into one of the cells in xcell it throws the zero away. What do I do to fix this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with entering cell number
You can enter your number and then format it to display with leading zeroes.
Example: enter 123 and custom format the display as 00000. Your number will display as 00123. "Magda" wrote in message ... When entering a cell number into one of the cells in xcell it throws the zero away. What do I do to fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering a number in any cell eg. 1 it changes to 0.01 why | Excel Discussion (Misc queries) | |||
entering number down to cell | Excel Discussion (Misc queries) | |||
Problems entering a formula | Excel Worksheet Functions | |||
How do I make lines appear after entering a number in a cell? | Excel Discussion (Misc queries) | |||
problems entering in numbers | Excel Discussion (Misc queries) |