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
 

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

Custom cell format for Scientific Notation 4
Removing Scientific Notation 8
Avoid Scientific Notation 2
large numbers as text replaced with scientific notation 2
DataSet.WriteXML writes decimals in Scientific Notation 2
Text fields displayed as scientific Notation 1
Excel reading pasted values as Scientific Notation 3
text converted to scientific notations 3

Back
Top