Scientific notation
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Scientific notation

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Greg,

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

    Bye,
    Jay

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #7
    New Member
    Join Date
    Mar 2009
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #8
    New Member
    Join Date
    Feb 2008
    Location
    Greater Detroit
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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

  9. #9
    New Member
    Join Date
    Feb 2008
    Location
    Greater Detroit
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Scientific notation

      
    See sites.google.com/site/ExcelSigFigs

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com