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. |
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 |
All times are GMT +1. The time now is 01:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com