Custom Formatting
 

How to format into Engineering units instead of scientific units?
--
Tony Reflinski

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

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

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

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