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.


Download Practice Workbook

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


7 Methods to Convert Percentage to Decimal in Excel

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.

Related Content: How to Convert Percentage to Number in Excel (5 Easy Ways)


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.

Read More: How to Convert Date to Number in Excel (4 Methods)


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.

Read More: How to Convert Scientific Notation to Number in Excel (7 Methods)


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 decimal now.

Read More: How to Convert Degrees Decimal Minutes to Decimal Degrees in Excel


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, 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 (7 Methods)


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.

Read More: How to Fix Convert to Number Error in Excel (6 Methods)


7. VBA Function to Convert Percentage to Decimal

We can apply a 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.

Read More: How to Convert String to Number in Excel VBA (3 Methods)


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.

Conclusion

In this article, we described 7 methods to convert percentages to decimal numbers in Excel. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.


Related Articles

Alok Paul

Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo