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

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

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