Excel demonstrates Percentage value in Number format when we apply formula to calculate percentage. In this article, we will learn how to convert Number to Percentage format in Excel in 3 convenient ways.
📁 Download Excel File
Download the following Excel workbook to realize the topic more clearly.
Learn How to Convert Number to Percentage in Excel with 3 Easy Approaches
Today we will use this sample dataset to convert Number to Percentage in Excel.
1. Using Number Format Drop-Down Menu from Excel Ribbon
In this approach, we will show how to convert Number to Percentage in Excel using the Number Format Drop-down menu.
- In the beginning, select cell E6. We will calculate Profit Percentage using the following formula:
=(D6-C6)/C6
- At this time, move the cursor to the bottom right corner of cell E6. To use the Fill Handle Tool, double-click.
- Magically, we will get the Profit Percentage just like in the picture below.
- Afterward, navigate to the Home tab and click the drop-down menu from the Number group.
- Next, click Percentage.
- You will see that all the values of the Profit Percentage column are now in the Percentage format.
2. Applying Custom Category from Format Cells Option
It is time for applying the Custom category from the Format Cells option to convert Number to Percentage in Excel.
- Initially, apply the following formula to cell E6.
=(D6-C6)/C6*100
- Later, use the Fill Handle Tool to apply the formula to the other cells.
- Now, the dataset will look like the following screenshot.
- Next, go to the Home Click the dialog launcher under the Number group.
- A Format Cells dialog box will appear on the screen. Or you can just press Ctrl+1 concurrently.
- After that, select Custom. Then, write the following number format code in the Type box and click OK.
=0.00\%
- This code will let the Profit Percentage column show the percentage format in 2 decimal places.
3. Executing Pivot table to Convert Number to Percentage
In our final approach, we will learn how to convert Number to Percentage in Excel using Pivot Table.
- First, enter the following formula into cell E6.
=(D6-C6)/C6
- Use the Fill Handle Tool and get the following result.
- After, select cells B5 to E10.
- Next, navigate to the Insert tab and click PivotTable.
- A PivotTable from table or range dialog box will pop up.
- Afterward, select the New Worksheet button and click OK.
- In the new worksheet, go to the PivotTable Fields from the right side.
- At this moment, drag Products to the Rows and similarly drag Profit Percentage to Values.
- A Pivot Table will automatically show the following result.
- Now, double-click on the Sum of Profit Percentage header.
- A Value Field Settings will show up.
- Click Number Format.
- Eventually, a Format Cells dialog box will come.
- Next, select Percentage and click OK.
- Voila! The Sum of Profit Percentage column is showing Profit Percentage in Percentage.
How to Convert Number to Percentage Using Excel Charts
Sometimes, we need to show values in charts to better grasp the concept. Here, we will show how to show the Profit Percentage in a column chart in the Percentage format.
- First of all, select cells B5 to B10. Simultaneously, press Ctrl and select cells E5 to E10.
- This time, navigate to the Insert tab and select Insert Column or Bar Chart.
- From the 2-D Column, select Clustered Column.
- A Clustered Column will pop up in the worksheet.
- Now, double-click on the vertical axis.
- A Format Axis option bar will appear on the right side of the worksheet.
- Then, from the Number drop-down menu, go to the Category option.
- Here, click on the drop-down menu.
- Later, select Percentage.
- Consequently, the values of the vertical axis will be in the Percentage format.
📝 Takeaways from This Article
📌 Firstly, we learned how to use Number Format Drop-down menu to convert Number to Percentage format.
📌 Secondly, we applied Custom category using the Format Cells dialog box to convert Number to Percentage in Excel.
📌 Thirdly, we executed a Pivot Table to convert Number to Percentage format.
📌 Finally, we demonstrated the Profit Percentage in a Clustered Column chart.
Conclusion
That concludes the discussion for today. These are some convenient methods to convert number to percentage in Excel. If you have any queries or recommendations, kindly notify us in the comments section. Downloading the practice sheet will help you comprehend the concepts better. Visit our website ExcelDen to find out about diverse kinds of Excel methods. We appreciate you taking the time to read this article.