Scientific notation

GregPascal

New Member
Joined
Apr 7, 2002
Messages
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.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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.
 
Upvote 0
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?
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,144
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top