+ Reply to Thread
Results 1 to 3 of 3

Fractional Percentage format

Hybrid View

  1. #1
    Registered User
    Join Date
    06-06-2006
    Location
    English(UK)
    MS-Off Ver
    2019
    Posts
    93

    Fractional Percentage format

    How do I get excel to display very small percentages in scientific notation?
    It should look something like this:

    Value: 0.2 Result 20%
    Value: 0.0005 Result: 0.05%
    Value: 0.0000000005 Result: 5E-8%

  2. #2
    Registered User
    Join Date
    10-05-2010
    Location
    S.A
    MS-Off Ver
    Excel 2007
    Posts
    99

    Re: Fractional Percentage format

    hi
    select the cells, right click
    format cells - tab number - custom
    you select percentage format code
    in type you can write how many digits
    to appear after zero. like this format:
    0.000000000% then ok.
    thanks

  3. #3
    Registered User
    Join Date
    06-06-2006
    Location
    English(UK)
    MS-Off Ver
    2019
    Posts
    93

    Re: Fractional Percentage format

    Something that does not require 500px wide cells would be nice too...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1