Forcing scientific notation to a specific power

C

C.O.

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?
 
D

David Biddulph

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).
 
Top