See screenshot: 3. So, even if you’ve used number formatting to display something as a percentage (10%), that’s just what it is—formatting, or a symbolic representation of the underlying value. In the example below, Actual Points/Possible Points = Grade %: Now, if you type 0.1 in the cell, Excel will return 0% or 0.10% depending on the decimal setting. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day. In the opening Add Text dialog box, type % into the Text box, check the After last character option, and make sure the Skip non-text cells option in unchecked, finally click the Ok button. Full feature free trial 30-day, no credit card required! If you want to add percentage sign to a number without multiplying the number by 100, such as to change 6 into 6% in Excel with Percentage Style, you should have the general number divided by 100 first, and then apply the Percentage Style to the numbers for displaying them as percentage 6% in Excel. Calculating a percentage in Excel is an easy two-step process. Negative percentages—If you want negative percentages to be formatted differently—for example, to appear as red text or within parentheses—you can create a custom number format such as 0.00%;[Red]-0.00% or 0.00%_);(0.00%). So for example, if you type 10 into cell A2 and then apply the percentage number format, Excel will multiply your number by 100 to show it as a percentage (remember that 1% is one part of one hundred), so you’ll see 1000% displayed in the cell, not 10%. 1. Free Trial Now! For this example, the formula you would use is =A1* (1-B1). Generally, when you add a percentage sign to a number in Excel, it will multiply the number by 100 firstly, and then insert the percentage symbol behind the number. See screenshot: 2. Editor’s note 3/7/2019: Office 2019 is the next on-premises version of Word, Excel, PowerPoint, Outlook, Project, Visio, Access, and Publisher. This article will guide you to add only the percentage sign for both single and multiple general numbers in cells quickly. In the Operation Tools dialog box, select the Division in the Operation list, enter 100 in the blank box in Operand section, and click Ok button. So if you only want to add a percentage single behind the number, you can do the following steps: Then all numbers in the selected range are added the percentage sign as soon as possible without multiplying 100. Here are a few things to keep in mind when formatting percentages: Format existing values—When you apply percentage formatting to a cell that already has a number in it, Excel multiplies that number by 100 and adds the % sign at the end. (See Rounding issues below for more information.). button under Home tab, or right click > Format cells > Percentage > OK. By doing this, it won't only add a percentage sign to the number, but also to multiply the number by 100. Get It Now. The second method would be to convert the percent value to a string, remove the percent symbol and treat the remainder as a value. For example, if you type 10 or .1 in a preformatted cell, you’ll see 10% appear in the cell. For example, it'll convert the number 6 to 600% in the cell. Keep selecting the new range, and click Home > Percentage button . Format empty cells—Excel behaves differently when you pre-format empty cells with percentage formatting and then enter numbers. I.e. As with any formula in Excel, you need to start by typing an equal sign (=) in the cell where you want your result, followed by the rest of the formula. Also, start your free trial of Excel. Steht in der Zelle bereits eine Zahl, wird diese mal 100 gerechnet (aus 20 wird 2000%).