# How to Convert Percentage to Number in Excel (5 Easy Ways)

### Method 1 – Convert Percentage to a Number from the Home Tab

Let’s use a dataset that contains the information of sales for two months of some sellers. The change between the months is calculated in Column E and shown in percentages. Let’s convert the difference to a number.

Steps:

• In the first place, select the cell(s) you want to convert to a number. We have selected Cell E6Â here.

• Go to the Home tab and select the â€˜Percentageâ€™ box. A drop-down menu will open.

• Select Number from there.

• The selected percentages will be converted into a number like below.

• Use the Fill Handle to convert other percentages.

• To show the decimal numbers, 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.

• Use the Fill Handle to see results in all cells.

### Method 2 – Use Format Cells Window to Change Percentage to a Number

Steps:

• Select the cells you want to convert to numbers. We have selected Cell E6 to Cell E11.

• Go to the Home tab and select the Number group anchor. The â€˜Format Cellsâ€™ window will appear.

• You can also right-click the mouse and then select Format Cells to open the window.

• Select â€˜Numberâ€™ and change â€˜Decimal placesâ€™ toÂ 2.

• Click OK to see results like below.

### Method 3 – Convert Percentage to a Numbers with Excel Custom Formatting

Steps:

• Select the range of cells you want to convert to numbers. We have selected Cell E5 to Cell E11.

• Open the Format CellsÂ window (right-click and select Format Cells).
• Select the Number tab and then select CustomÂ from the Category.
• Write 0.00 in the Type field.

• Click on OK to see the results.

• You can also show the output to four decimal points. To do that, write 0.0000 in place of 0.00.

• Click on OK to see results like below.

### Method 4 – Apply NUMBERVALUE Formula to Convert Percentages to Numbers in Excel

Steps:

• Select Cell F6.
• Copy this formula into it:
=NUMBERVALUE(E6)

• Hit Enter and drag the Fill Handle down to see the results.

• You can use the â€˜Format Cellsâ€™ settings to show only four decimals after a point.

• To convert the values into percentages, multiply the cells by 100.
=NUMBERVALUE(E6)*100

• You can see the first result below.

• Use the Fill HandleÂ to see the results in all cells.

### Method 5 – Use Copy & Paste Values to Convert Percentages to Numbers in Excel

Steps:

• Select the cells you need to convert. We have selected Cell E6 toÂ Cell E11.

• Press Ctrl + C to copy them.

• Select the first cell of the Helper Column, right-click, and use Paste Values like below.

• Here’s what will show up as the result.

• Use the Format Cells window to display numbers to four decimal places.

## Related Articles

<<Go Back to Calculating Percentages in Excel

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF