| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format numbers in engineering units (e.g. m, u, n)
How do I format my data to display in engineering units. For example if a
cell had a value of 0.000015 it is displayed as 15n and if it was 0.022 it displays as 22m and for 34000 it displays as 34k. It must be possible to do this but I cannot fnd it in help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I format numbers using engineering notation in excel? | Excel Discussion (Misc queries) | |||
| Engineering format | Excel Discussion (Misc queries) | |||
| I wish to display numbers in engineering format (exponents * 3). | Excel Discussion (Misc queries) | |||
| Can I fix the exponent in scientific/engineering format? | Excel Discussion (Misc queries) | |||
| displaying numbers in engineering notation | Excel Discussion (Misc queries) | |||
Threaded Mode
