Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to prevent General format from using scientific notation?
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
|
|||
|
|||
How to prevent General format from using scientific notation?
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 | |
|
|
Similar Threads | ||||
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) |