How to Change Decimals to Percentages in Excel (4 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

How to Change Decimals to Percentages in Excel


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.

How to Change Decimals to Percentages in Excel

Finally, we can see the change in the Deviation Percentage column from decimals to percentages.

How to Change Decimals to Percentages in Excel

Read More: How to Change International Number Format in Excel


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.

How to Change Decimals to Percentages in Excel

  • 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.

How to Change Decimals to Percentages in Excel

Read More: How to Change Comma to Dot in Excel


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+%.

How to Change Decimals to Percentages in Excel

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.

How to Change Decimals to Percentages in Excel


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


<< Go Back to Change Number Format | Number Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo