Easy Change Whole Number to Percent 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 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.
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.
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.
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.
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.
Now you've got all the percentage values with 2 decimal places.
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.
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.
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)
Source: https://www.exceldemy.com/convert-number-to-percentage-in-excel/
0 Response to "Easy Change Whole Number to Percent Excel"
Post a Comment