Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing scientific notation to a specific power
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing scientific notation to a specific power
"C.O." wrote in message
... 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? Try http://pubs.logicalexpressions.com/p...cle.asp?ID=414, which will tell you how to get numbers into engineering format (or related formats). -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scientific notation | Excel Discussion (Misc queries) | |||
Excle should allow define a fix exponent in scientific notation | Excel Discussion (Misc queries) | |||
Mail Merge and Scientific Notation | Excel Discussion (Misc queries) | |||
Removing Scientific Notation | New Users to Excel | |||
convert scientific notation to a number | Excel Discussion (Misc queries) |