Can I format numbers using engineering notation in excel?

[elwilliamson]

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

 

[Joel]

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

 

[Bernard Liengme]

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/ExcelTips/EngineeringNotation.htm

best wishes

 

[elwilliamson]

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?

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/ExcelTips/EngineeringNotation.htm

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

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

 

[KErickson]

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

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/ExcelTips/EngineeringNotation.htm

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

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

 

[David Biddulph]

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

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

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/ExcelTips/EngineeringNotation.htm

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

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