View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Annette Annette is offline
external usenet poster
 
Posts: 32
Default 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