Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The default is to display any number of ovver 12 digits as sci-not which can
truncate precision and causes problems with exports and other uses. Is there a way to defeat this behaviour. I, personally, would preffer treating it as text, but a simple long integer would be fine, too. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you want to treat the value as text, either preformat the cell as text or
start your data entry with an apostrophe: '123412341234 (or give it a Number format with as many decimals as you want) jim swanson wrote: The default is to display any number of ovver 12 digits as sci-not which can truncate precision and causes problems with exports and other uses. Is there a way to defeat this behaviour. I, personally, would preffer treating it as text, but a simple long integer would be fine, too. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent Scientific Notation | Excel Discussion (Misc queries) | |||
Cell changes from General format to Scientific | Excel Worksheet Functions | |||
scientific notation | Excel Discussion (Misc queries) | |||
Custom format for scientific notation | New Users to Excel | |||
Scientific notation | Excel Discussion (Misc queries) |