How to prevent General format from using scientific notation?

J

jim swanson

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.
 
D

Dave Peterson

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)
 
Top