How to Convert Number to Percentage in Excel (3 Quick Ways)

Converting a number or decimal or fraction is very easy to do with Microsoft Excel. Technically Excel will convert any input data into a percentage by multiplying it by 100 & adding a percentage symbol on the right if you opt to choose percentage formatting. But you can also convert a number directly to a percentage value without letting it be multiplied by 100 in Excel. Here are some useful & basic methods I’ve tried to illustrate how you can do them both.


Download Practice Worksheet

You can download the worksheet here to practice which we’ve used to prepare this article.


3 Suitable Methods to Convert Number to Percentage in Excel

1. Converting Decimal to Percentage with Number Format Commands

Suppose, a business company has decided to determine the Profit Percentage for 12 months in a particular year. They have calculated the amount of profits subject to cost prices which are displayed as decimals in Column B. Now they want to convert these data into percentages.

Converting Decimal to Percentage with Number Format Commands

Steps:

⇒ Select all cells containing the decimals and numbers in Column B.

⇒ Under the Home tab, click on ‘%’ (Percent Style) from the Number group of commands.

Converting Decimal to Percentage with Number Format Commands

You’ve just converted all decimals into percentages right away as shown in the picture below.


2. Using Custom Format Option to Convert Number to Percentage in Excel

Now let’s assume, the company has already calculated its percentage values & now they just want to add Percentage symbols beside all values without changing the data.

Step 1:

⇒ Like the previous method, select all the cells containing the percentage values first.

⇒ Under the Home tab & from the Number group of commands, click on Number Format.

Custom Format Option to Convert Number to Percentage in Excel

A new tab box named Format Cells will appear.

Step 2:

⇒ Select Custom formatting from the Number tab.

⇒ Now you have to customize your format by typing in place of General inside the Type box.

Custom Format Option to Convert Number to Percentage in Excel

Step 3:

⇒ Type 0\% & Press OK.

You’ll get all the values in percentage format at once.

Step 4:

⇒ If you want to add decimal places then again open Format Cells.

⇒ Now replace 0\% with 0.00\% if you want to add 2 decimal places.

⇒ Click OK or press Enter & you’re done.

Custom Format Option to Convert Number to Percentage in Excel

Now you’ve got all the percentage values with 2 decimal places.

Custom Format Option to Convert Number to Percentage in Excel


3. Converting a Resultant Fraction or Number to Percentage in Excel

Now we have a datasheet containing the cost prices & selling prices over a year for a business company and we have to find the percentage profits by converting calculated profit values into percentages.

Step 1:

⇒ Select Cell D2.

⇒ Under the Home tab, choose Percentage format from the drop-down in the Number group of commands.

⇒ In Cell D2, type =(C2-B2)/B2 & press Enter

You’ve just calculated the profit percentage for January.

Converting a Resultant Fraction or Number to Percentage in Excel

Step 2:

⇒ Now in Cell D2, point your mouse cursor onto the right bottom corner & you’ll find a ‘+’ icon there which is known as Fill Handle.

⇒ Select the Fill Handle icon & drag it to Cell D13.

Converting a Resultant Fraction or Number to Percentage in Excel

Step 3:

⇒ Release the mouse button & the whole percentage profits for all months in the specific year will be shown right away.


Conclusion

So, these are the most common & effective methods you can use anytime while working with your Excel datasheet to calculate percentage values or convert any type of number into a percentage. If you got any questions, suggestions, or feedback related to this article you can comment below. You can also have a look at our other useful articles on Excel functions & formulas on this website.


Further Readings

Nehad Ulfat

Nehad Ulfat

Hello, Welcome to my profile. I'm a Technical Content Creator as well as a Naval Architect & Marine Engineer. I have preferences to do analytical reasoning & writing articles on various statistical data. Here, you'll find my published articles on Microsoft Excel & other topics related to my interests!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo