Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number entry starting with a "0", how do I view correctly?
If a cell contains a number series, such as 01239, how do I prevent the first
"0" from being omitted? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number entry starting with a "0", how do I view correctly?
hi,
excel strips off leading zeros because mathmatically, they are unnecessary. usully such "numbers" are some kind of id and are technically not numbers because you don't really want to do mathmatical stuff with them anyway. to keep the leading zeros, prefomat as text or preceed entry with an apostrophe. regards FSt1 "Monique" wrote: If a cell contains a number series, such as 01239, how do I prevent the first "0" from being omitted? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number entry starting with a "0", how do I view correctly?
You'd have to enter the number as a TEXT string.
Either preformat the cell as TEXT or precede the entry with an apostrophe: '01239. The apostrophe does not display in the cell. Another possibility, if the length of all entries is to be the same, you could use a custom number format like: 00000. Using this method the leading zero(s) will *display* 01239 but the true underlying value of the cell will be 1239. -- Biff Microsoft Excel MVP "Monique" wrote in message ... If a cell contains a number series, such as 01239, how do I prevent the first "0" from being omitted? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to confirm entry in Col "C" is valid for data in Col "A" | Excel Discussion (Misc queries) | |||
How do I replace decimals starting with "." to "0." in excel? | Excel Discussion (Misc queries) | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Duplicate entry "x" number of times | Excel Discussion (Misc queries) | |||
Missing "Custom View" entry from View menu | Excel Discussion (Misc queries) |