Comments on: How to show percentages in Excel

In this short tutorial, you will find many helpful details about Excel percent format and learn how to make Excel display percentages in the way you want.  Continue reading →

Table of contents

Comments page 2. Total comments: 42

  1. I have one question.
    Suppose you entered a value as 0.72 in a number field having percentage format. But in place of 72% , it is displaying 100%. Can you find out a reason.

  2. What is the formula for converting a raw mark that is not out of 100 (e.g 46/60) into a percentage? Thank you

    1. Hello,

      If I understand your task correctly, please try to use one of the following formulas:

      =46/60*100

      Or

      =TEXT(46/60,"0.00%")

      Hope it will help you.

      1. Thank you for the simple formlula...it really helped me

  3. When i add percentage sign ..... with 20 it becomes 2000% ..... i need just only 20 .00%

    1. Hi Asim,

      You can type %20 in an empty cell and Excel will display it properly.
      However, to format existing numbers as percentages, you have to divide them by 100 first, and then apply the Percent format. For the detailed explanation, please see Format existing values as percentage

  4. Help please. How do I calculate the discount percentage of a product. EG item is $1000 and now discounted to Sales Price of $500 What formula do I use to show 50%
    Thank you

  5. 2000/- and 200/- less amount
    What is the Percentage of Discount

  6. If I have a line item that has a $0 budget but spent $400. How do I show that in percent?

  7. have an unusual problem with Excel 2010. I have a file created with Excel 2013 with percentages and money values and it all looks fine in 2013. When I open it in 2010 it does not show the percentage, but shows me 0.9540 instead of 95.40%. PLZZZZ HELP ME

  8. Thanks

  9. Hi,
    Is there a way I can use any function to convert a part of the calculation to percentage?
    To give an example - I'm using a formula to show notes in my report where I want to show the max savings (in %) from a particular location/country (dynamic).
    A sample formula would be -
    ="Maximum savings from "&ROUND(MAX(H23:K23),2)&" comes by transitioning to "&(HLOOKUP(MAX(H23:K23),H23:K24,2,FALSE))

    In the above example:
    1. "ROUND(MAX(H23:K23),2)" is used to calculate and show the percentage (somehow it is showing in decimals currently). This is what I want to show as %.
    2. "(HLOOKUP(MAX(H23:K23),H23:K24,2,FALSE))" is used to calculate and show the location where the maximum savings are coming from.

    The end result as seen now is "Maximum Savings of 0.8 comes by transition to India". :(
    Suggestions would be really appreciated. thanks in advance.

  10. How can I calculate the prcentage of $8660 in one cells its a revenue

    1. Hi Gurpreet,

      Simply multiply the original number by the desired percentage. For example:
      =A1*10% or =A1*0.1

      1. 1
        1
        4
        10
        6
        19
        25
        23

        Total value
        89. how can i find percentage of all these values

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)