T
Tony Reflinski
How to format into Engineering units instead of scientific units?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
Format Custom ##0.0E+0
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
T
Tony Reflinski
BRILLIANT, Thanks
Niek Otten said:Format Custom ##0.0E+0
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
K
KErickson
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,
are all formatted that way, how can I use formulas to add or subtract? Thanks,
D
David Biddulph
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
formatting of the cells doesn't affect what number is stored, merely how it
is displayed. --
David Biddulph