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.
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.
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.
2. Applying Format Cells Feature to Change Decimals to Percentages
In this method, we will use the 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.
3. Changing Decimals to Percentages Through Keyboard Shortcut in Excel
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.
4. Applying Excel Paste Special Feature for Changing 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 > 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.
Download Workbook
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, please contact us in the comment section.
Related Articles
- How to Change Comma to Dot in Excel
- How to Change International Number Format in Excel
- How to Convert European Number Format to US in Excel
- [Solved] Excel Number Stored As Text
- How to Convert Percentage to Decimal in Excel
- Excel Number Format Not Working
- [Solved:] Long Numbers Are Displayed Incorrectly in Excel
- How to Display Long Numbers in Excel
- How to Enter 16 Digit Number in Excel
- How to Enter 20 Digit Number in Excel
- How to Convert Exponential Value to Exact Number in Excel
- How to Format Number with VBA in Excel