| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scientific vs Floating with General Number Format - Quickie
Hi Joe
many thanks for that research best wishes Tim "JoeU2004" wrote in message ... "Tim Childs" wrote: Is there a simple rule that Excel uses to determine when it switches from floating to scientific when it chooses how to display a number that is in a cell which is number formatted to "General"? Empirically, it appears that happens when an integer requires more than 11 digits or when a number less than one requires more than 9 digits (11 characters included "0."). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show to stop scientific numbers from general formating | Excel Discussion (Misc queries) | |||
| How to prevent General format from using scientific notation? | Excel Discussion (Misc queries) | |||
| Cell changes from General format to Scientific | Excel Worksheet Functions | |||
| General number format | Excel Discussion (Misc queries) | |||
| Global fix for scientific number format? | Excel Discussion (Misc queries) | |||
![Tim Childs[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
