# Convert Number to Percentage Without Multiplying by 100 in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.

### 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

The CONCAT function concatenates a list or range of text strings.

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.

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

## 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.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems. Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  