Scientific notation-one exponent for all values
 

I'm working with a worksheet where we'd like all the entries to have the same
expoenent, even if they are different oders of magnitude. For example:
1.2e4, 1.2e5 and 1.2e6 should display as 0.012e6, 0.12e6 and 1.2e6 (to make
comparisons visually easier). Is there a way to set the format of the cell
to make this happen?
Thanks for you help.
Annette

Scientific notation-one exponent for all values
 

Divide all the numbers by 1E6
Then use Custom format 0.0000 "E+06"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Annette" wrote in message
...
I'm working with a worksheet where we'd like all the entries to have the
same
expoenent, even if they are different oders of magnitude. For example:
1.2e4, 1.2e5 and 1.2e6 should display as 0.012e6, 0.12e6 and 1.2e6 (to
make
comparisons visually easier). Is there a way to set the format of the
cell
to make this happen?
Thanks for you help.
Annette

Scientific notation-one exponent for all values
 

Thank you, this worked perfectly!
Annette

"Bernard Liengme" wrote:

Divide all the numbers by 1E6
Then use Custom format 0.0000 "E+06"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Annette" wrote in message
...
I'm working with a worksheet where we'd like all the entries to have the
same
expoenent, even if they are different oders of magnitude. For example:
1.2e4, 1.2e5 and 1.2e6 should display as 0.012e6, 0.12e6 and 1.2e6 (to
make
comparisons visually easier). Is there a way to set the format of the
cell
to make this happen?
Thanks for you help.
Annette