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