# 3 Effective Approaches to Convert Number to Percentage in Excel

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.

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

Approach

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

⬇️⬇️ STEPS ⬇️⬇️
• 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.

Approach

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

⬇️⬇️ STEPS ⬇️⬇️
• 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.

Approach

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

⬇️⬇️ STEPS ⬇️⬇️
• 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.

Note: The Pivot Table will automatically sort your dataset alphabetically.

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

⬇️⬇️ STEPS ⬇️⬇️
• 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.

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