6 Ways to Convert Percentage to Decimal in Excel

Organizing data using various techniques is quite common in Excel. Records are arranged in a tabular form here. In cases of calculation, you may use percentages. Although percentages are easy to calculate, sometimes you may want the decimal form of the data. There are many ways to convert a percentage to a decimal. This article will discuss six approaches to how you can convert a percentage to a decimal in Excel. It applies to any set of data and you can eventually modify it according to your requirements. Moreover, all the methods have step-by-step instructions with figurative descriptions.


📁 Download Excel File

Download the Excel file below.


Learn to Convert Percentage in Excel to Decimal with These 6 Approaches

The article is going to introduce six ways to convert a percentage to a decimal. The following discussion will cover the uses of format changes to General, Number, and Text formats in three ways. There is a method using the Paste Option. You can also use the NUMBERVALUE function and VBA Macro Code to convert a percentage to a decimal. Therefore, users will get a walkthrough of these solutions. You will find a dataset to modify in the following methods below to help you understand.

Dataset for converting percentage to decimal


approach

1. Using General Format

The easiest method to convert percentage values to decimal values in Excel is converting them to the General format.

⬇️⬇️ STEPS ⬇️⬇️

  • First, select the cell range E8:E11.
  • Second, go to the drop-down option from the Number group under the Home tab.
  • Third, select the General format.

Using General format to convert percentage to decimal

  • Fourth and finally you will have all your percentage data in decimal format.

Format change to convert percentage values to decimal values

📕 Read More: Convert Degrees Minutes Seconds to Decimal Degrees in Excel


approach

2. Switching to Number Format

If you change your Percentage format to Number format, you will automatically get its decimal value.

⬇️⬇️ STEPS ⬇️⬇️

  • Initially, select the cell range E8:E11.
  • Next, go to the drop-down option from Number group under Home tab.
  • Then, select Number format.

Switching to Number format to convert percentage to decimal in Excel

  • Finally, you will have all your percentage data in decimal format.

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


approach

3. Implementing Text Format

The Text format is generally used to add text strings in a cell. Now you can change your percentage values into decimal numbers by changing their formats into the Text format.

⬇️⬇️ STEPS ⬇️⬇️

  • In the beginning, select the cell range E8:E11.
  • Then, select the drop-down option from Number group under the Home tab.
  • After that, select the Text format.

Implementing Text format to convert percentage to decimal

  • Therefore, you will have all your percentage data in decimal format.


approach

4. Utilizing Paste Options

The basic feature of copying data is Ctrl+C. Now you can paste the copied data to another cell(s). While pasting, there are a variety of options available on how you want to paste the data. Using the Paste Option to get the Values option can help you to convert a percentage to decimal in Excel.

⬇️⬇️ STEPS ⬇️⬇️

  • To begin with, select the cell range D8:D11.
  • Next, press Ctrl+C in order to copy the data.
  • Now, click on the cell range E8:E11 and right-click on it.
  • Then, choose the Values icon from the Paste options.

Utilizing paste options for converting percentage to decimal in Excel

  • Finally, you will have all your percentage data in decimal format.


approach

5. Applying NUMBERVALUE Function

NUMBERVALUE function returns the value from a data cell no matter in which form the source data was.

⬇️⬇️ STEPS ⬇️⬇️

  • Initially, select cell E8.
  • Next, enter following formula.
=NUMBERVALUE(D8)
  • Now, hit the Enter key.

Applying NUMBERVALUE function to convert percentage to decimal

  • Here, copy the formulas down their cells using Fill Handle icon.
  • Finally, you will have all your percentage data in decimal format.


approach

6. Employing VBA Code

Using VBA (Visual Basic for Applications), you can employ Macro code to apply on your worksheet. Moreover, it is also the only method that will create a new function in order to convert your percentage values to decimal values in Excel automatically. With the proper instruction, you can make your work easier.

⬇️⬇️ STEPS ⬇️⬇️

  • First, press Alt+F11 to open the Visual Basic Application (VBA).
  • Second, select the Module option from Insert You can also press Alt+I+L for the action.
  • Third, write following code in the Module box.
Function Decimal_number(n_number As String) As Double
n_number = Left(n_number, Len(n_number))
Decimal_number = Val(n_number) / 1
End Function
  • Fourth, you should see the window like the image below.

  • Fifth, select cell E8.
  • Sixth, enter the following formula.
=Decimal_number(D8)
  • Seventh, hit the Enter key.

Employing VBA macro code to convert percentage to decimal

  • Eighth, copy the formulas down their cells using Fill Handle icon.
  • Ninth and finally, you will have all your percentage data in decimal format.


📄 Important Notes

🖊️  All the data formats must be formatted properly. Otherwise, Excel may auto-format to something inappropriate for the user.


📝 Takeaways from This Article

The article lets the readers understand the variety of options available to generate a list based on criteria in Excel.

📌  Primarily, you can change the percentage format to the General format. It returns the decimal format usually.

📌  Also, you can use the Number format from the Percentage format.

📌  You can change your percent values in the Text format as well. It will convert a percentage to a decimal number as well.

📌  Ctrl+C can copy your percentage data. You need to try the Paste Values option.

📌  You can also apply the NUMBERVALUE function.

📌  Finally, you can make use of VBA Macro Code to convert your percentage values to decimal values in Excel.


Conclusion

To convert a percentage to decimal in Excel, six methods are available. You can try format changes to General, Number, and Text formats in three ways. The Paste Options, the NUMBERVALUE function, and VBA Macro Code can be of help to convert a percentage to a decimal. In case of further queries, readers are requested to leave a comment for the author. The author will try their best to come up with a suitable solution. Follow ExcelDen to get more access to solutions regarding your Excel problems.


Related Article

(Visited 51 times, 1 visits today)
Farihat

Farihat

An Excel enthusiast who wants to share and loves to solve Excel problems. I try to explore available options to guide readers to the maximum ways how they can solve. The world is limitless, and so are the problems in it. Let's help each other to grow. I would love to hear feedback and queries from readers. You can visit my LinkedIn for further information.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo