The percentage is the fraction of two numbers multiplied by 100. Mathematically, we need to multiply a number by 100 to convert that into a percentage. But Excel has other options to convert a number to a percentage without multiplying that by 100. In this article, we will discuss those methods with proper illustrations.
Convert Number to Percentage Without Multiplying by 100 in Excel: 5 Methods
We will discuss 5 methods including different shortcuts and formulas to convert numbers to percentages without multiplying by 100. Look at the below section for details.
We will consider the dataset which contains profit percentage months of the year 2021 in decimal form. We need to convert that into percentile.
1. Using Keyboard Shortcut
The easiest way to convert the numbers in the Profit Percentage column is to apply a keyboard shortcut. Just in the blink of an eye, we will see the result. Let’s do it.
📌 Steps:
- First, select Range C5:C16.
- Then, press Ctrl+ Shift + % on the keyboard and look at the dataset.
We can see all are showing the percentile form.
Read More: How to Divide a Value to Get a Percentage in Excel
2. Using the % Button from Ribbon to Convert Number into Percentage
In this section, we will show a ribbon shortcut to convert numbers into a percentage.
📌 Steps:
- First, select the data range.
- Then, click on the Percentage symbol showing in the Number group.
- Look at the dataset now.
Numbers are converted into a percentage. We can increase the decimal places in the result if they are lost.
- Again, select the dataset. Then, click on the Increase Decimal option from the Number group.
We can see hidden decimal points are shown in the result.
3. Applying Custom Format
In this section, we will convert the number into a percentage using the Custom section of the Format Cells window.
📌 Steps:
- Like the previous methods, select the data range first.
- Then, press the Ctrl+1 to get the Format Cells window.
- The Format Cells window appears.
- Choose the Custom option from the Number tab.
- Input 0% in the Type section.
- Now, press the OK button and look at the dataset.
We can see the result is shown in percentage form. But notice that no decimal point is showing in the result.
- Again, enter the Format Cells window.
- Change the previous Type and replace that with 00%.
- Again, look at the dataset.
Lost decimal places are retrieved here.
4. Using CONCAT Function to Convert Number into Percentage
In this section, we will use the CONCAT function. This will add a percentage symbol to the data. Previously, we used the CONCATENATE function. This CONCAT function is the updated form of the CONCATENATE function available in the latest Excel versions.
📌 Steps:
- First, we add a new column on the right side to show the result converting to percentage.
- Put the following formula on Cell D5.
=CONCAT(C5/0.01,"%")
In this formula, we divide the numbers of Column C by 0.01 and then add the percentage symbol (%).
- Now, press the Enter button and drag the Fill Handle icon.
We successfully converted numbers into a percentage.
5. Convert Number to Percentage in Excel Pivot Table
This method is based on the Pivot table. A pivot table is one of the most useful features of Excel. Have a look at the below discussion.
We were given a dataset of each month’s profit of 2021 of a super shop. First, we will calculate the profit percentage for each month based on the total profit of the year.
📌 Steps:
- Put the following formula on Cell D5.
=C5/SUM($C$5:$C$16)
Here, we used the SUM function to get the total profit for the year 2021. Then, use this value to divide each month’s profit. We use the absolute cell reference in the SUM function as months this range is fixed.
- Now, press the Enter button and drag the Fill Handle icon.
- Now, we will proceed to the Pivot Select the whole dataset.
- Then, click on the Pivot Table option from the Insert tab.
- A new window appears.
- We choose the Existing Worksheet option to place the Pivot table.
- Then, select a cell in the worksheet for the Location section.
- Then, press the OK button.
- The PivotTable Fields section appears.
- Tick the Month option and place that in the Rows field.
- Again, tick the Profit Percentage option and place this in the Values field.
- Look at the dataset.
We can see the result is in decimal form.
- Move the cursor to the Sum of Profit Percentage cell and press the right button of the mouse.
- Choose Value Field Settings from the Context Menu.
- The Value Filed Settings window appears.
- Choose the Show Values As option.
- Then, click on the drop-down symbol as marked in the image.
- Choose the % of Column Total option.
- Finally, press the OK button.
The number of our dataset is now converted to a percentage.
How Do I Remove Percentage Symbol in Excel Without Changing Values?
In this section, we want to remove the percentage symbol in Excel without any value. For that, we will use a formula based on the combination of VALUE, TEXT, LEFT, and LEN functions.
- The VALUE function converts a text string that represents a number to a number.
- The TEXT function converts a value to text in a specific number format.
- The LEN function returns the number of characters in a text string.
- The LEFT function returns the specified number of characters from the start of a text string.
Look at the below section. We have the following dataset for this operation.
📌 Steps:
- Just go to Cell D5 and insert the following formula.
=VALUE(LEFT(TEXT(C5,"00.00%"),LEN(C5)-1))
- Then, press the Enter button and drag the Fill Handle icon.
We can see percentage symbol has been removed without changing the values. We can also say this is the percentage value without a symbol.
Formula Breakdown:
- TEXT(C5,”00.00%”)
This converts any value in the given format in the formula.
Result: 30.00%
- LEN(C5)
This defines the length of Cell C5.
Result: 3
- LEFT(TEXT(C5,”00.00%”),LEN(C5)-1)
This returns characters from the start. How many digits will appear depends on the LEN function.
Result: 30
- VALUE(LEFT(TEXT(C5,”00.00%”),LEN(C5)-1))
The VALUE function converts text strings into numbers.
Result: 30
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
In this article, we described 5 different methods to convert a number to a percentage without multiplying by 100 in Excel. We also showed how to remove the percentage symbol without changing the value. I hope this will satisfy your needs.
Related Articles
- How to Calculate Percentage of Total in Excel
- How to Convert Number to Percentage in Excel
- How to Calculate Reverse Percentage in Excel
- How to Find the Percentage of Two Numbers in Excel
- How to Convert Percentage to Number in Excel
- How to Convert Percentage to Whole Number in Excel
- How to Show One Number as a Percentage of Another in Excel
- How to Add a Percentage to a Number in Excel
- Make an Excel Spreadsheet Automatically Calculate Percentage
<<Go Back to Calculating Percentages in Excel | How to Calculate in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
