Scientific vs Floating with General Number Format - Quickie

T

Tim Childs

Hi

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"?

thanks

Tim
 
J

JoeU2004

Tim Childs said:
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"?
Click to expand...

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.").
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Scientific Notation 1
Stop XL from changing format? 1
Excel does not accept text format! 0
How do I stop Excel 2007 from using scientific notation? 2
Import hexadecimal data into excel keeping hexadecimal format 1
Cell Formatting Defaults To Scientific 1
how can I save an excel file with long number columns in cvs form. 3

Top