How to Convert Percentage to Decimal in Excel (7 Methods)

Get FREE Advanced Excel Exercises with Solutions!

In Microsoft Excel, we can represent a piece of data in different forms. The percentage is one of them. A percentage is the presentation of numeric data based on the ratio of 100. Sometimes we need the decimal format instead of the percentage format. We will discuss how to convert this percentage to decimal in Excel in this tutorial.


How to Convert Percentage to Decimal in Excel: 7 Methods

We will show 7 simple methods to convert a percentage to decimal in Excel. We will consider the dataset below. It contains the monthly growth rate of the 1st six months of 2021 of a superstore.


1. Convert Percentage to Decimal Using the General Format

We will use the General format to convert the percentage to decimal in this section. Apply the following steps.

Steps:

  • First, select Cell C5 to Cell C10.
  • From the Home tab go to Number group.
  • Click on the arrow icon and choose General from the list.

Convert Percentage to Decimal Using the General Format in Excel

Look at the data set now.

Our data is converted into decimal from the percentage.

Read More: How to Convert European Number Format to US in Excel


2. Apply Number Format to Convert Percentage to Decimal

This method is a bit similar to the previous method. We will apply the Number format here. Just follow the steps below.

Steps:

  • Select Cell C5 to C10 which contains percentage data.
  • Go to the Number group from the Home tab.
  • Choose Number from the Number Format options.

Number Format to Convert Percentage to Decimal in Excel

Look at the dataset again.

We get data in our desired decimal format.


3. Use the Custom Format Cells to Convert Percentage to Decimal

We will apply the customized options of Format Cells in this section.

Steps:

  • Select Cells C5 to C10.
  • Now, click the arrow marked on the Number group.

Excel Custom Format Cells to Convert Percentage to Decimal

  • Go to the Custom option from the list of Number tab.
  • Select a suitable decimal format from the list, then press OK.

Excel Custom Format Cells to Convert Percentage to Decimal

Notice the Growth Rate column of the dataset.

All percentage data are converted to decimal now.


4. Simple Copy-Paste Method to Convert Percentage to Decimal

Copy & Paste is one of the widely used tools of Microsoft Excel. We can use this tool to convert a percentage to a decimal.

We add a column named Decimal Form in the dataset for this purpose.

Now follow the steps below.

Steps:

  • Then, go to Cell D5.
  • Press the right button of the mouse.
  • Choose Values(V) from the Paste Options.

Simple Excel Copy-Paste Method to Convert Percentage to Decimal

Finally, look at the dataset.

In the new column, given percentage data are transformed into decimals now.


5. Apply Excel Paste Special Method to Convert Percentage

The Paste Special command has some lucrative facilities while performing data paste. We will use this tool in this section.

Steps:

  • Choose Cells C5 to C10 first.
  • Press Ctrl+C to copy them.
  • Go to Cell D5, and click the right button of the mouse.
  • Click Paste Special from the list.

Apply Excel Paste Special Method to Convert Percentage

  • The Paste Special window will appear. Choose Values from that window and then press OK.

Apply Excel Paste Special Method to Convert Percentage

Notice the Decimal Form column now.

Related Content: How to Convert Exponential Value to Exact Number in Excel


6. Excel NUMBERVALUE Function to Convert Percentage to Decimal

The NUMBERVALUE function converts any argument to a number.

We will use this function to convert the percentage to a decimal.

Steps:

  • Now, go to Cell D5.
  • Write the following formula on that cell.
=NUMBERVALUE(C5)

Excel NUMBERVALUE Function to Convert Percentage to Decimal

  • Now, press the Enter button.

  • Pull the Fill Handle icon for the rest of the cells.

Excel NUMBERVALUE Function to Convert Percentage to Decimal

All the percentage data are converted into decimal now.


7. VBA Function to Convert Percentage to Decimal

We can apply a custom VBA function to convert the percentage to a decimal.

Steps:

  • Go to the Record Macro option from the Developer tab.
  • Set the name of the macro and then press OK.

Excel VBA Function to Convert Percentage to Decimal

  • Now, click on the Macros command.
  • Select the macro and click on Step Into.

  • Write the following VBA code on the command module.
Function D_number(P_number As String) As Double
P_number = Left(P_number, Len(P_number))
D_number = Val(P_number) / 1
End Function

Excel VBA Function to Convert Percentage to Decimal

  • Save the code.
  • Now, go to Cell D5 of the dataset.
  • Put the formula below.
=D_number(C5)

Excel VBA Function to Convert Percentage to Decimal

  • Press the Enter button and drag the Fill Handle icon.


Convert Number to Percentage without Multiplying by 100

We can convert any number to a percentage without multiplying by 100. The following dataset is considered for this purpose.

Now, follow the steps below.

Steps:

  • First, select Cells C5 to C10.
  • Choose Percentage sign(%) from the Number group of the Home tab.
  • Or we can press Ctrl+Shift+%.

Convert Number to Percentage without Multiplying by 100 in Excel

Look at the dataset now.


Things to Remember

  • We need a helper column while using the Paste tool and functions.
  • You can enter Format Cells by pressing Ctrl+1 also.
  • We do not need to run the VBA code, just save the code and apply the function on the dataset.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

In this article, we described 7 methods to convert percentages to decimal numbers in Excel. I hope this will satisfy your needs. Please give your suggestions in the comment box.


Related Articles


<< Go Back to Change Number Format | Number Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo