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.
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.
- Fourth and finally you will have all your percentage data in decimal format.
Read More: Convert Degrees Minutes Seconds to Decimal Degrees in Excel
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.
- Finally, you will have all your percentage data in decimal format.
Read More: Convert Degrees Decimal Minutes to Decimal Degrees in Excel
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.
- Therefore, you will have all your percentage data in decimal format.
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.
- Finally, you will have all your percentage data in decimal format.
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.
- Now, hit the Enter key.
- Here, copy the formulas down their cells using Fill Handle icon.
- Finally, you will have all your percentage data in decimal format.
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.
- Seventh, hit the Enter key.
- 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.