Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format Issue
When enter 899405090111023400
in my excell sheet, it always convert to 899405090111023000 why is this? changing cell format doesn't help -- mar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format Issue
"marlon" wrote:
When enter 899405090111023400 in my excell sheet, it always convert to 899405090111023000 why is this? Because Excel treats that as a number. On data entry, Excel will convert only the first 15 significant digits. Moreover, Excel will display only the 15 significant digits. changing cell format doesn't help Actually, it does -- if you format the cell as Text before entering data. Alternative, type an apostrophe (single quote) before the first digit. That will cause Excel to treat the data entry as text, even if the cell is formatted as General or a numeric format. This presumes that you do not intend to use the number in arithmetic expressions, but instead the number is really as identifier (product number, transaction number, etc). If you do intend to use the number in arithmetic expressions, you are almost SOL. For some numbers, there are ways to enter more than 15-digit precision. But the result is really an approximation anyway; and as I indicated, success depends on the number. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format Issue
Excel handles up to 15 digits.
Micky "marlon" wrote: When enter 899405090111023400 in my excell sheet, it always convert to 899405090111023000 why is this? changing cell format doesn't help -- mar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell 2003 Cell format issue | Excel Discussion (Misc queries) | |||
Format Issue | Excel Worksheet Functions | |||
Cell Format Issue | Excel Discussion (Misc queries) | |||
Format of Cell an Issue | Excel Worksheet Functions | |||
# format issue | Excel Discussion (Misc queries) |