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