Engineering Notation

[GregPascal]

Is there a way to force Excel to format scientific notation such that the exponents are in multiples of three?
10^9, 10^6, 10^3, ones, io^-3, 10^-6, 10^-9, etc. That way the answers will be in engineering terms.

 

[Mark W.]

See http://www.stfx.ca/people/bliengme/ExcelTips/EngineeringNotation.htm.

 

[crook_101]

selling cross reported.......

 

[pbornemeier]

Does this custom format do what you want?
###.###E+0

 

[xenou]

Or wait another year and reply to a thread that is actually ten years old ...

 

[pbornemeier]

I figured that the question was still out there and didn't have a good answer yet, so what the heck!

 

[xenou]

Better late than never, eh?

 

[bobJR]

Thanks. First result in google too.

 

[zerink]

No matter how long the question was posted / answered, there is always someone looking for the answer lilke me...
Thanks so much, I wish I knew that before...


Eric