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

format the cell as scientific. In the Format Menu - Select Cells - Numbers -
Scientific

"elwilliamson" wrote:

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

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

Thank you for the info. That works fine.
I still can't understand why Microsoft doesn't have this as a standard
choice on the number format menu. Engineering notation is widely used by
engineers. Many of them use Excel often to analyze data. MS, are you
listening?

"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

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

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