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


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


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

Afia Kona
Afia Kona

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo