How to Convert a Number to Percentage in Excel

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.

To add decimal places:

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

Replace 0\% with 0.00\% to add 2 decimal places.
Click OK or press ENTER.

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.