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