# How to Add a Percentage to a Number in Excel (3 Easy Methods)

Each of the methods in this tutorial use the following sample data set:

## Method 1 – Change the Style of Numbers to Add Percentage to Number in Excel

Steps:

• Divide the cell value of C5 by 100 and insert the following formula in cell D5.
=C5/100

• Press Enter and use AutoFill to show results for the entire column.

• Select the data range D5:D14 and go to Home
• Select the Percent Style option under the Number section, or you can pressÂ  Ctrl+Shift+% Â as well.

• Excel will multiply the cells with 100 to convert the number into percentages and add a % sign at the end of the values as an indicator.

## Method 2 – Apply Excel Formula to Add a Percentage to a Number

### Method 2.1 – Add Direct Percent to a Number

Steps:

• Take the following data set where you will determine the increased price of given items on a fixed percentage, say 10% for this example.

• Write the following formula in cell D7.
=C7+C7*\$C\$4

• Press Enter to get the desired result in cell D7.
• Use AutoFill to drag the formula to the lower cells of the column.

### Method 2.2 – Divide Percent Value by 100

Steps:

• Enter the following formula in cell D7 to find out the percentage.
=C7+C7*(10/100)
• Here, you have divided 10 by 100 instead of using direct percent in the result.

• PressÂ Enter to see the result in cell D7.
• Use Fill Handle to show the result for the lower cells of the column.

### Method 2.3 – Use Decimal Equivalent

Steps:

• Type the following formula in cell D7.
=C7*1.1
• Here, instead of using 10% in the formula, you will use its decimal equivalent, which is 1.1.

• Hit the Enter button to see the result.
• Copy the formula to the lower cells using AutoFill.

## Method 3 – Use Excel’s Paste Special Tool to Add Percentage to a Number

Steps:

• Using the below dataset, copy and paste the price values of column C into column D.

• Select cell C5 and pressÂ  Ctrl + C to copy the value.
• Select the data range D8:D17.

• Right-click on the mouse after selecting the data range.
• From the context menu, select Paste Special.

• Select Values under the Paste label in the resulting dialog box.
• Under the Operation label, select Multiply.
• Press OK.

• The percentage will be added to the numbers of the selected data range and the result will look like the following image.

## Add Percentage to a Number in Excel: Knowledge Hub

<< Go Back to Calculating PercentagesÂ | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Chinmoy Mondol

Chinmoy Mondol is a computer engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in C, C++, Python, JavaScript, HTML, SQL, MySQL, PostgreSQL, Microsoft Office, and VBA and goes beyond the basics. He holds a B.Sc. in Computer Science and Engineering from American International University-Bangladesh. He has transitioned into the role of a content developer. Beyond his work, find him immersed... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF