| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Custom Formatting
How to format into Engineering units instead of scientific units?
-- Tony Reflinski |
|
#2
|
|||
|
|||
|
Format Custom ##0.0E+0
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Tony Reflinski" wrote in message ... How to format into Engineering units instead of scientific units? -- Tony Reflinski |
|
#3
|
|||
|
|||
|
BRILLIANT, Thanks
"Niek Otten" wrote: Format Custom ##0.0E+0 -- Kind Regards, Niek Otten Microsoft MVP - Excel "Tony Reflinski" wrote in message ... How to format into Engineering units instead of scientific units? -- Tony Reflinski |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Formatting
Thanks for posting the hint about engineering formatting. If A1, B1 and C1
are all formatted that way, how can I use formulas to add or subtract? Thanks, -- Keri "Niek Otten" wrote: Format Custom ##0.0E+0 -- Kind Regards, Niek Otten Microsoft MVP - Excel "Tony Reflinski" wrote in message ... How to format into Engineering units instead of scientific units? -- Tony Reflinski |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Formatting
You use the formula to add or subtract or whatever in the normal way. The
formatting of the cells doesn't affect what number is stored, merely how it is displayed. -- David Biddulph "KErickson" wrote in message ... Thanks for posting the hint about engineering formatting. If A1, B1 and C1 are all formatted that way, how can I use formulas to add or subtract? Thanks, -- Keri "Niek Otten" wrote: Format Custom ##0.0E+0 -- Kind Regards, Niek Otten Microsoft MVP - Excel "Tony Reflinski" wrote in message ... How to format into Engineering units instead of scientific units? -- Tony Reflinski |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom formatting | Excel Discussion (Misc queries) | |||
| custom cell formatting | Excel Discussion (Misc queries) | |||
| Custom Formatting a number | Excel Discussion (Misc queries) | |||
| Custom Number formatting | Excel Worksheet Functions | |||
| Custom formatting | Excel Discussion (Misc queries) | |||
Linear Mode
