Use + to add, - to subtract.
--
David Biddulph

"KErickson" wrote in message
...
If I recieve a document with numbers formatted in ##0.00E+0 or ##0.0E+0,
how
can I add or subtract these?
Thanks,
--
Keri


"Bernard Liengme" wrote:

This can be done with a custom format such as ##0.00E+0 or ##0.0E+0 but
this
gives poor results with number less than 1,000.

This custom format works better: [<0.001]##0.00E+0;[<1000] #0.00;##0.00E

See http://people.stfx.ca/bliengme/Excel...ngNotation.htm

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"elwilliamson" wrote in message
...
Is there a way to format numbers in excel in engineering format where
the
exponent is always a multiple of 3?

Examples
2.6e3
34.7e-9
But not 3.47e-8