Forcing scientific notation to a specific power

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

Guest

I'm trying to force all my scientific notation numbers to be raised to the
same power. For example, when I enter 0.103E+06 in a cell, it gets converted
to 1.03E+05. In this case, I'd like all my numbers to be raised to the sixth
power for easier comparison between the numbers. Is there any way to do this
in Excel?
 
C.O. said:
I'm trying to force all my scientific notation numbers to be raised to the
same power. For example, when I enter 0.103E+06 in a cell, it gets
converted
to 1.03E+05. In this case, I'd like all my numbers to be raised to the
sixth
power for easier comparison between the numbers. Is there any way to do
this
in Excel?
Click to expand...

Try http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=414, which
will tell you how to get numbers into engineering format (or related
formats).
 
Back
Top