Adding a percentage to a number in MS Excel generally means two things. One is that you want to** convert a number to a certain percentage**, and the other is that you want to increase a value by a particular rate. I’ve addressed both of these concerns and also covered the basics and other commonplace uses of percentages in Excel. In this article, I will show you how to add a percentage to a number in Excel.

**Table of Contents**hide

## Download Practice Workbook

You can download the free **Excel** workbook here and practice on your own.

## 3 Easy Ways to Add a Percentage to a Number in Excel

In this article, you will see three easy ways to add a percentage to a number in Excel. In the first procedure, I will change the style of numbers to add a percentage. Then, I will apply an arithmetic formula to add a percentage in the second method. Lastly, I will use the **Paste Special** command of Excel to add a percentage.

To illustrate our procedure further, I will use the following sample data set.

### 1. Change Style of Numbers to Add Percentage to a Number

This method shows how you can convert cells with numerical values to percentage values using the default options provided by Excel. Follow these steps for applying this solution.

**Steps:**

- First of all, to divide the cell value of
**C5**by**100**insert the following formula in cell**D5**.

`=C5/100`

- Secondly, press
**Enter**and use**AutoFill**to show results for the entire column.

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

- Consequently, it 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.

### 2. Apply Arithmetic Formula to Add a Percentage to a Number

In the second method, I will apply some arithmetic formulas to add a percentage to a number. Here, I will use the same formula in three different ways to add a percentage. All these methods will show the same result after the calculation.

#### 2.1 Add Direct Percent to a Number

In this section, I will apply the direct percent in the formula to get the desired value. By following this formula, you can add **10** percent to a number in Excel. Follow the below-given steps for applying the formula.

**Steps:**

- First of all, take the following data set where you will determine the increased price of given items on a fixed percentage, say
**10%**for this example.

- Secondly, to apply the direct percent in the formula, write the following formula in cell
**D7**.

`=C7+C7*$C$4`

- Thirdly, press
**Enter**to get the desired result in cell**D7**. - After that, use
**AutoFill**to drag the formula to the lower cells of the column.

#### 2.2 Divide Percent Value by 100

In the second part, I will apply the percent in the formula but not directly like in the previous method. Instead of using a direct percentage, I will divide the percent value by** 100** and then insert it into the formula. To do that, see the following steps.

**Steps:**

- First of all, use the following formula in cell
**D7**to find out the percentage.

`=C7+C7*(10/100)`

- Here, I have divided
**10**by**100**instead of using direct percent in the result.

- Secondly, to see the result in cell
**D7**press**Enter**. - Afterward, with the help of
**Fill Handle**, show the result for the lower cells of the column.

#### 2.3 Use Decimal Equivalent

The last part of this section deals with using the decimal equivalent of a percent value in the formula. For doing that, see the following steps.

**Steps:**

- Firstly, to use the decimal equivalent in the formula, type the following formula in cell
.*D7*

`=C7*1.1`

- Here, instead of using
**10%**in the formula, I will use its decimal equivalent which is**1.1**.

- Secondly, hit the
**Enter**button to see the result, and then for showing the formula to the lower cells use**AutoFill**.

**Read More: How to Show Percentage Change in Excel Graph (2 Ways)**

### 3. Use Paste Special to Add Percentage to a Number

In the last method of this article, I will show you how to apply a percentage to a whole data range. Here, you don’t have to apply any formula or use **AutoFill **to show the final result. See the following steps for a better understanding.

**Steps:**

- First of all, see the following image where I changed the percentage to
**110%**from**10%**to multiply it with the prices. - Then, copy and paste the price values of column
**C**into column**D**just like in the following image.

- Secondly, select cell
**C5**and press**Ctrl + C**to copy the value. - Then, select the data range
**D8:D17**.

- Thirdly, right-click on the mouse after selecting the data range, and then from the context menu select
**Paste Special**.

- Fourthly, you will see the
**Paste Special**dialog box, in there under the**Paste**label select**Values**. - Then, under the
**Operation**label select**Multiply**. - Lastly, press
**OK**.

- Finally, after the previous steps, the percentage will be added to the numbers of the selected data range and the result will look like the following image.

**Read More: How to Display Percentage in an Excel Graph (3 Methods)**

## Conclusion

That’s the end of this article. I hope you find this article helpful. After reading the above description, you will be able to add a percentage to a number in Excel. Please share any further queries or recommendations with us in the comments section below.

The** ExcelDemy** team is always concerned about your preferences. Therefore, after commenting, please give us some moments to solve your issues, and we will reply to your queries with the best possible solutions ever.