# How to Convert a Number to Percentage in Excel – 3 Methods

### Method 1 – Using the Percent Style Button in the Number Group

A company needs to determine the Profit Percentage for 12 months. They have calculated the amount of profits which are displayed as decimals in the columnÂ  Percentage Profit. To convert the numbers into percentages:

Steps:

• Select all cells containing decimals and numbers in the Percentage Profit column.
• In the Home tab, click % (Percent Style) in Number.

Percentages are displayed.

### Method 2 – Utilizing the Custom Number Format Option

To add Percentage Symbols beside all values without changing the data:

Steps:

• Select all the cells in the Percentage Profit column.
• In the Home tab, select Number and click Number Format.

• In Format Cells will appear, select Custom inÂ Number.
• Click General in Type.

Note: You can press CTRL + 1 to open the Format Cells dialog box.

• Enter the following format code in Type.
`0\%`
• Click OK.

All values are in percentage format.

• Select the cells in the Percentage Profit column and go to the Home tab.
• Click Number Format in Number.

You will see percentage values with 2 decimal places.

### Method 3 – Converting a Resultant Fraction or Number to a Percentage in Excel

To find the Percentage Profits:

Steps:

• Use the following formula in E5.
`=(D5-C5)/D5`

D5 refers to the cell in the Selling Price column, and C5 indicates the cell in the Cost Price column.

• Press ENTER.

This is the output.

• Follow the steps in the 2nd method to obtain the following output in E5.

• In E5, point your mouse cursor to the right bottom corner, and youâ€™ll find a â€˜+â€™ icon: the Fill Handle.
• Drag down the Fill Handle to see the result in the other cells.

• The Percentage Profits for all Months are displayed.

## How to Convert a Number to Percentage in an Excel Pivot Table

Pivot Tables can be used to convert numbers to percentage format.

The dataset showcases the Yearly Profit Analysis of a company. To convert numbers in the Percentage Profit column into percentage:

Steps:

• Select the dataset and go to the Insert tab.
• Select Pivot Table in Tables.

• Choose New Worksheet in the dialog box PivotTable from table or range.
• Click OK.

The Pivot Table Fields dialog box will be displayed.

• Select Month and drag it into Rows.
• Select Percentage Profit and drag it into Values.

This is the output.

• Right-click C4 and click Value Field Settings.

• In the Value Field Settings dialog box, go to Show Values As.
• Click the drop-down icon.
• Choose % of Column Total.
• Click OK.

This is the final output.

Read More: How to Do Sum of Percentages in Excel

## How to Convert Number to Percentage in Excel Charts

Steps:

• Select the dataset and go to the Insert tab.
• Select Insert Column or Bar Chart in Charts.
• Choose Clustered Column.

The following chart will be displayed.

• Double-click the vertical axis of the chart.

The Format Axis dialog box will be displayed.

• In Format Axis, select Number and click the drop-down icon under Category.
• Choose Percentage.

This is the output.

Practice here.

## Related Articles

<<Go Back to Calculating Percentages in Excel

Get FREE Advanced Excel Exercises with Solutions!