How to apply the percentage number format without decimal places in Excel

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 & a

How to apply the percentage number format without decimal places in Excel

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 Ive tried to illustrate how you can do them both.


Table of Contents hideDownload Practice Worksheet3 Suitable Methods to Convert Number to Percentage in Excel1. Converting Decimal to Percentage with Number Format Commands2. Using Custom Format Option to Convert Number to Percentage in Excel3. Converting a Resultant Fraction or Number to Percentage in ExcelConclusionFurther Readings

Download Practice Worksheet

You can download the worksheet here to practice which weve used to prepare this article.Convert Number to Percentage.xlsx


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

Youve 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 lets 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.

Youll 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 & youre done.

Custom Format Option to Convert Number to Percentage in Excel

Now youve 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

Youve 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 & youll find a + icon there which is known as Fill Handle.

Select the Fill Handleicon & 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

  • Convert Percentage to Basis Points in Excel (Basis Point Calculation)
  • How to Calculate Discount Percentage Formula in Excel
  • How to Calculate Growth Percentage Formula in Excel
  • Excel Formula to Add Percentage Markup [with Calculator]
  • Excel formula to calculate the percentage of grand total (4 Easy Ways)
  • Calculate Excel percentage difference between two numbers (using formula)
  • Percentage Difference Between Two Percentages Excel (2 Easy Ways)
  • How to Calculate Grade Percentage in Excel (2 Easy Ways)
  • Subtract a Percentage in Excel (Easy Way)

Video liên quan