| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scientific notation of CSV | Excel Discussion (Misc queries) | |||
| scientific notation | Excel Discussion (Misc queries) | |||
| Excle should allow define a fix exponent in scientific notation | Excel Discussion (Misc queries) | |||
| Can I fix the exponent in scientific/engineering format? | Excel Discussion (Misc queries) | |||
| Scientific notation | Excel Discussion (Misc queries) | |||
Hybrid Mode
