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

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.

How to Change Decimals to Percentages in Excel


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.

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

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 Fix Decimal Places in Excel (7 Simple Ways)


Similar Readings


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

How to Change Decimals to Percentages in Excel

We can see the result in cell D5.

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.

How to Change Decimals to Percentages in Excel


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.


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

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo