Scientific notation

GregPascal · Apr 8th, 2002, 03:42 PM

Does anyone know how to force Excel to use engineering notation? Engineering notation forces the exponent into multiples of 3.
10^6, 10^3, 10^-3, 10^-6, etc. are standard engineeing prefixes.

Parra · Apr 8th, 2002, 04:41 PM

I am not sure if this is what you are looking for but in column A row 1 write 3 and in row two write 6 and then click and drag down, it will grow in mulitples of 3. In column b write =10^a1 then click and drag the formula.

Jay Petrulis · Apr 8th, 2002, 04:47 PM

Hi Greg,

Format>Cells>Custom
Choose as Type:
##0.0E+0

Bye,
Jay

Mark W. · Apr 8th, 2002, 05:01 PM

As posted earlier...

http://www.mrexcel.com/board/viewtop...4362&forum=2&1

GregPascal · Apr 8th, 2002, 05:45 PM

What I am trying to do is to force Excel to use exponents in increments of 3.

Normally, the number 1.21e-4 is fine in scientific notation, but I'd rather see it as 0.121E-3 in engineering notation. Assuming it is volts, then we have 0.121 mV.

Does htan make sense?

Mark W. · Apr 9th, 2002, 07:34 AM

Quote:

On 2002-04-08 16:45, GregPascal wrote:
What I am trying to do is to force Excel to use exponents in increments of 3.

Normally, the number 1.21e-4 is fine in scientific notation, but I'd rather see it as 0.121E-3 in engineering notation. Assuming it is volts, then we have 0.121 mV.

Does htan make sense?

When you format 1.21E-4 as ##0.0E+0 you get 121.0E-6. What's the problem with that?

willhen50 · Mar 8th, 2009, 04:40 AM

I have used the method described and I get just a consistant value, like all the values are E+ or E- 3, but I am trying to convert those values to the engineering format, such as K, m, G, et al.

I bought a calculator for less than $10 and it converts to the engineering format. Why would a super calculator like Excel not have this feature?

Inquiring minds just want to know.

CycleTimeChart · Apr 4th, 2009, 04:29 PM

I constructed a VBA program that handles this problem (i.e. engineering format).

Trying to sell this program.

Send me an email for a demo.

DavidLNewton@yahoo.com

CycleTimeChart · Apr 17th, 2009, 11:09 PM

See sites.google.com/site/ExcelSigFigs

Mar 8th, 2009, 04:40 AM	#7
willhen50 New Member Join Date: Mar 2009 Posts: 4	Re: Scientific notation I have used the method described and I get just a consistant value, like all the values are E+ or E- 3, but I am trying to convert those values to the engineering format, such as K, m, G, et al. I bought a calculator for less than $10 and it converts to the engineering format. Why would a super calculator like Excel not have this feature? Inquiring minds just want to know.

Apr 4th, 2009, 04:29 PM	#8
CycleTimeChart New Member Join Date: Feb 2008 Location: Greater Detroit Posts: 13	Re: Scientific notation I constructed a VBA program that handles this problem (i.e. engineering format). Trying to sell this program. Send me an email for a demo. DavidLNewton@yahoo.com

Apr 17th, 2009, 11:09 PM	#9
CycleTimeChart New Member Join Date: Feb 2008 Location: Greater Detroit Posts: 13	Re: Scientific notation See sites.google.com/site/ExcelSigFigs

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

Apr 8th, 2002, 03:42 PM	#1
GregPascal New Member Join Date: Apr 2002 Posts: 6	Does anyone know how to force Excel to use engineering notation? Engineering notation forces the exponent into multiples of 3. 10^6, 10^3, 10^-3, 10^-6, etc. are standard engineeing prefixes.

Apr 8th, 2002, 04:41 PM	#2
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	I am not sure if this is what you are looking for but in column A row 1 write 3 and in row two write 6 and then click and drag down, it will grow in mulitples of 3. In column b write =10^a1 then click and drag the formula.

Apr 8th, 2002, 04:47 PM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi Greg, Format>Cells>Custom Choose as Type: ##0.0E+0 Bye, Jay

Apr 8th, 2002, 05:01 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	As posted earlier... http://www.mrexcel.com/board/viewtop...4362&forum=2&1

Apr 8th, 2002, 05:45 PM	#5
GregPascal New Member Join Date: Apr 2002 Posts: 6	What I am trying to do is to force Excel to use exponents in increments of 3. Normally, the number 1.21e-4 is fine in scientific notation, but I'd rather see it as 0.121E-3 in engineering notation. Assuming it is volts, then we have 0.121 mV. Does htan make sense?