Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Engineering format
I make graphs with frequency on the X-axis, so I naturally use logarithmic scale and the labels in the engineering format, ie. the exponent is multiples of 3 to denote the prefixes milli-, mega-, kilo-, etc. When the labels are printed they are written as 10E-03, 10E06, 10E03, etc. 1) Is it possible to avoid the E00, when the unit stands alone without prefix? 2) Is it possible to create a format which replaces the 'E-09' with 'nano' or just 'n', 'E09' with 'Giga' or 'G', etc.? NSV -- nsv ------------------------------------------------------------------------ nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500 View this thread: http://www.excelforum.com/showthread...hreadid=544588 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) |