Thanks:  0
Likes:  0

# Thread: Scientific notation

1. 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.

2. 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.

3. Hi Greg,

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

Bye,
Jay

4.

5. 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?

6. 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?

7. ## 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.

8. ## 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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•