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