Custom format for scientific notation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thanks! I doubt we'll ever reach the billions, so I think we're safe
using this format. Whew, these are too complicated!
Melinda
 
Back
Top