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