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.

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:

• 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.

• 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.

Download Practice Book

Download the practice book.

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