Hello,
I have a spreadsheet in which I would like one value to always be displayed
in scientific notation with E6. The number gets put into a nomograph which
uses values in the millions, so it's easiest to see if my value is written
this way.
Example: 1,234 would display as 0.001234E6
I've tried ##0.00E0, but if the value is less than 100,000 it displays as E3.
Any ideas?
Thanks!
Melinda

As long as you don't have any values greater than or equal to 1E9, you
can fake it:

Format/Cells/Number/Custom [<1000000]\0\.000000\E+6;##0.000000E+0




In article ,
"Melinda" wrote:

Hello,
I have a spreadsheet in which I would like one value to always be displayed
in scientific notation with E6. The number gets put into a nomograph which
uses values in the millions, so it's easiest to see if my value is written
this way.
Example: 1,234 would display as 0.001234E6
I've tried ##0.00E0, but if the value is less than 100,000 it displays as E3.
Any ideas?
Thanks!
Melinda

Thanks! I doubt we'll ever reach the billions, so I think we're safe
using this format. Whew, these are too complicated!
Melinda

JE McGimpsey wrote:
As long as you don't have any values greater than or equal to 1E9, you
can fake it:

Format/Cells/Number/Custom [<1000000]\0\.000000\E+6;##0.000000E+0