| 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 |
| 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) | |||
Threaded Mode
