In this article, we will learn to convert aÂ percentage to a number in Excel. Sometimes, we need to change the percentage formatting in number formatting for our desired output. In an Excel worksheet, we can easily show a percentage in a number format. Here, we will demonstrate five easy and quick ways to convert a percentage to a number in Excel.

## What is Percentage?

In simple language, a percentage is a number or a ratio expressed as a fraction of **100**. It is denoted by the **percent (%) sign. **Suppose, there are **300 **students in a class, and **150 **of them are male. If we divide the male students by the total number of students and multiply it by **100**, then we will get **50%. **It means there are 50% (fifty percent) male students or the percentage of male students is **50**.

## How to Convert Percentage to Number in Excel: 5 Methods

### 1. Convert Percentage to Number from the Home Tab

In excel, we can convert any percentage to a number using the **Home **tab. To explain this method, we will use a dataset that contains the information of **sales amount** of two months of some sellers. The amount of increase concerning the second month is calculated in **Column E** and shown in percentage. We will try to convert these percentages to numbers here.

Letâ€™s follow the steps to learn more.

**STEPS:**

- In the first place, select the cell you want to convert to a number. We have selected
**Cell E6Â**here.

- Secondly, go to the
**Home**tab and select the**â€˜Percentageâ€™.**A drop-down menu will occur.

- Thirdly, select
**Number**from there.

- After that, the selected percentage will be converted into a number like below.

- Finally, use the
**Fill Handle**to convert the other percentages.

- To show the decimal numbers, like the percentage values, just multiply the cell formula or the cell by
**100.**

`=(D6-C6)/D6*100`

Here, we used this formula to calculate the ratio of the increase. And then we multiplied it by **100. **

- Hit
**Enter**to see the result.

- Again, use the
**Fill Handle**to see results in all cells.

### 2. Use Format Cells Window to Change Percentage to Number

We can also use the â€˜**Format Cells**â€™ window to change a percentage to a number in Excel. We will use the same dataset here. Letâ€™s observe the steps below to learn this method.

**STEPS:**

- In the beginning, select the cells you want to convert to numbers. We have selected
**Cell E6**to**Cell E11.**

- Now, go to the
**Home**tab and select the**Number**dialog icon, like below. The**â€˜Format Cellsâ€™**window will appear.

- Similarly, you can also
**right-click**the mouse and then select**Format Cells**to open the window.

- Then, select
**â€˜Numberâ€™**and change**â€˜Decimal placesâ€™**toÂ**2.**

- Finally, click
**OK**to see results like below.

### 3. Convert Percentage to Number with Excel Custom Formatting

Custom formatting is another way to convert percentages to numbers. It is also quick and gives various opportunities to display the results. For this method, we will again use the same dataset.

Follow the steps below to learn this technique.

**STEPS:**

- Firstly, select the range of cells you want to convert to numbers. We have selected
**Cell E5**to**Cell E11**here.

- Now, open the
**â€˜Format Cellsâ€™**window using the**â€˜Numberâ€™**dialog icon like**Method-1.** - After that, select
**â€˜Numberâ€™**and then, select**â€˜Customâ€™.** - Then, write
**00**in the**Type**field.

- Finally, click
**OK**to see results like below.

- Moreover, you can also show the output to four decimal points. To do that, write
**0.0000**in place of**0.00.**

- Click
**OK**to see results like below.

### 4. Apply Formula to Convert Percentage to Number in Excel

Applying formulas in cells makes our task very easy in Excel. We can apply a formula to convert the percentages to numbers. For that, we will use the **NUMBERVALUE **function. The **NUMBERVALUE **function converts a number or percentage in text format to a numeric value. Here, we will use the same dataset but we need to create an extra column to apply the formula. Letâ€™s follow the steps to learn more about this method.

**STEPS:**

- First, select
**Cell F6.** - Second, type the formula:

`=NUMBERVALUE(E6)`

- Thirdly, hit
**Enter**and drag the**Fill Handle**down to see the results.

- Now, you can use the
**â€˜Format Cellsâ€™**to show only four decimals after a point.

- Then, to make the value of the numbers equal to the percentages, multiply the cells by
**100.**

`=NUMBERVALUE(E6)*100`

- Finally, you can see the results below.

- Furthermore, use the
**Fill HandleÂ**to see results in all cells.

### 5. Use of â€˜Copy & Paste Valuesâ€™ to Convert Percentage to Number in Excel

In this method, we will use the **â€˜Copy & Paste Valuesâ€™** feature of Excel. We will again add an extra column here.

Follow the steps to learn this technique.

**STEPS:**

- At first, select the cells you need to convert. We have selected
**Cell E6**toÂ**Cell E11.**

- Now, we need to copy them. To copy, you can press
**Ctrl**+**C**from the keyboard.

- Then, select the first cell of the
**Helper Column**and**Paste Values**like below.

- After that, you will see results like below.

- Finally, use the
**â€˜Format Cellsâ€™**window to display numbers to four decimal places.

## Things To Remember

There is an important thing you need to remember while converting percentages to numbers. When you are using the **â€˜Copy & Paste Valuesâ€™ **method, make sure the **Helper Column **is in **General **format.

**Download Practice Book**

Download the practice book.

## Conclusion

We have demonstrated five quick and easy ways to convert a percentage to a number in Excel. We have also discussed percentages at the beginning. I hope these methods will help you convert percentages into numbers very easily. You can also download the practice book to exercise. Last of all, if you have any queries or suggestions, feel free to ask in the comment section.

## Related Articles

- How to Calculate Percentage of Total in Excel
- How to Convert Number to Percentage in Excel
- How to Find the Percentage of Two Numbers in Excel
- How to Divide a Value to Get a Percentage in Excel
- How to Calculate Reverse Percentage in Excel
- How to Convert Percentage to Whole Number in Excel
- How to Show One Number as a Percentage of Another in Excel
- How to Add a Percentage to a Number in Excel
- Make an Excel Spreadsheet Automatically Calculate Percentage
- Convert Number to Percentage Without Multiplying by 100 in Excel

**<<Go Back to Calculating Percentages in Excel | How to Calculate in Excel | Learn Excel**