Engineering Notation

GregPascal · Apr 8th, 2002, 09:59 AM

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. · Apr 8th, 2002, 10:49 AM

See http://www.stfx.ca/people/bliengme/E...ngNotation.htm.

crook_101 · Oct 31st, 2010, 10:20 PM

selling cross reported.......

pbornemeier · May 8th, 2011, 09:40 PM

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

xenou · May 8th, 2011, 10:55 PM

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

pbornemeier · May 9th, 2011, 12:02 PM

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

xenou · May 9th, 2011, 06:34 PM

Better late than never, eh?

bobJR · Oct 9th, 2011, 12:23 AM

Thanks. First result in google too.

Oct 31st, 2010, 10:20 PM	#3
crook_101 Board Regular Join Date: Oct 2008 Location: Home: Sunny England Work: Rainy Scotland Posts: 631	Re: Engineering Notation selling cross reported....... __________________ There is no such thing as a stupid question. Anon But, if you work for me and ask a really stupid question, I will either laugh heartily or you get a really stupid answer

May 8th, 2011, 09:40 PM	#4
pbornemeier Board Regular Join Date: May 2005 Location: Virginia Beach, VA USA Posts: 1,562	Re: Engineering Notation Does this custom format do what you want? ###.###E+0 __________________ Phil Please use code tags [code]<your code here>[/code] to preserve indents when you post your code. I wish I had known before my first post! Display worksheets using Excel Jeanie or HTML Maker Test and validate results for all code on a copy of your worksheet!! How do you use the code you just found?

May 8th, 2011, 10:55 PM	#5
xenou MrExcel MVP Moderator Join Date: Mar 2007 Location: Cleveland OH Posts: 10,936	Re: Engineering Notation Or wait another year and reply to a thread that is actually ten years old ... __________________ Using: Office 2007/XP SP3 (work), Excel 2010/XP SP3 (home) One is not born into the world to do everything but to do something. -- Henry David Thoreau

May 9th, 2011, 12:02 PM	#6
pbornemeier Board Regular Join Date: May 2005 Location: Virginia Beach, VA USA Posts: 1,562	Re: Engineering Notation I figured that the question was still out there and didn't have a good answer yet, so what the heck! __________________ Phil Please use code tags [code]<your code here>[/code] to preserve indents when you post your code. I wish I had known before my first post! Display worksheets using Excel Jeanie or HTML Maker Test and validate results for all code on a copy of your worksheet!! How do you use the code you just found?

May 9th, 2011, 06:34 PM	#7
xenou MrExcel MVP Moderator Join Date: Mar 2007 Location: Cleveland OH Posts: 10,936	Re: Engineering Notation Better late than never, eh? __________________ Using: Office 2007/XP SP3 (work), Excel 2010/XP SP3 (home) One is not born into the world to do everything but to do something. -- Henry David Thoreau

Apr 8th, 2002, 09:59 AM	#1
GregPascal New Member Join Date: Apr 2002 Posts: 6	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.

Apr 8th, 2002, 10:49 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See http://www.stfx.ca/people/bliengme/E...ngNotation.htm.

Oct 9th, 2011, 12:23 AM	#8
bobJR New Member Join Date: Oct 2011 Posts: 1	Re: Engineering Notation Thanks. First result in google too.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode