If you want to change decimals to percentages in Excel, this article will be helpful to you. Here, we will walk you through 4 easy and effective methods to do the task effortlessly.
Download Workbook
4 Methods to Change Decimals to Percentages in Excel
The following Experiment Result table shows the Theoretical Value, Actual Value, and Deviation columns. In the Deviation column, we can see decimal data, and we want to change these decimals to percentages. We will use 4 methods to do the task. Here, we used Excel 365. You can use any available Excel version.
Method-1: Using Excel Number Format Option to Change Decimal to Percentages
Here, we will use the Number Format feature to change decimals to percentages.
Steps:
- First, we will select the entire data of the Deviation Percentage column
- After that, go to the Home tab > select the Number option > select Percent Style (%) which is marked with a red color box.
Finally, we can see the change in the Deviation Percentage column from decimals to percentages.
Read More: How to Remove Decimal Places in Excel (5 Easy Methods)
Method-2: Use of Format Cells Feature to Change Decimals to Percentages
In this method, we will use the Percentage Format Cells feature to change decimals to percentages.
Steps:
- First, we will select the entire data of the Deviation Percentage column and we will right-click.
- After that, we will select Format Cells from the Context Menu.
- A Format Cells window appears.
- After that, we will select Percentage from the Category > select a value in the Decimal places box, here we choose 2.
- Then, click OK.
Finally, we can see the change in the Deviation Percentage column from decimals to percentages.
Read More: How to Fix Decimal Places in Excel (7 Simple Ways)
Similar Readings
- Convert Decimal to Days Hours and Minutes in Excel (3 Methods)
- How to Reduce Decimals in Excel (10 Easy Methods)
- Set Decimal Places in Excel with Formula (5 Effective Ways)
- How to Remove Decimals in Excel with Rounding (10 Easy Methods)
Method-3: Using Keyboard Shortcut to Change Decimals to Percentages
Here, we will use a keyboard shortcut to change decimals to percentages in the Deviation Percentage column.
Steps:
- First, we will click on cell D5 and type CTRL+SHIFT+%.
We can see the result in cell D5.
- Afterward, we will drag down the formula with the Fill Handle tool.
Finally, we can see the change of decimals to percentages in the Deviation Percentage column.
Read More: How to Insert Dot between Numbers in Excel (3 Ways)
Method-4: Employing Excel Paste Special Feature to Change Decimals to Percentages
In this method, we will employ the Paste Special feature to change the decimals to percentages in the Deviation Percentage column.
Here, we will multiply the decimals of the Deviation Percentage column by 100 which is the value of cell D12.
Steps:
-
-
- First, we will right-click on cell D12 > we will select Copy from the Context Menu.
-
- After that, we will select the data of the Deviation Percentage column > go to the Home tab > click on Paste > select Paste Special.
A Paste Special window will appear.
- Afterward, we will select Values > select Multiply > click OK.
Finally, we can see that all the decimals of the Deviation Percentage column have been multiplied by 100.
Conclusion
Here, we tried to show you 4 methods to change decimals to percentages in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, feel free to know us in the comment section. Please visit our website Exceldemy to explore more.