Custom format for scientific notation

M

Melinda

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
 
J

JE McGimpsey

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
 
M

Melinda Chase

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

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

Top