# Convert Number to Percentage Without Multiplying by 100 in Excel

We will consider a simple dataset which contains profits for each month in decimal form. We need to convert that into percentile.

### Method 1 – Using the Keyboard Shortcut

Steps:

• Select the range C5:C16.

• Press Ctrl + Shift + %.

### Method 2 – Using the % Button from the Ribbon

Steps:

• Select the data range.
• Click on the Percentage symbol in the Number group.

• Here are the results.

• Select the dataset.
• Click on the Increase Decimal option from the Number group.

• We can see more decimal points for increased accuracy.

### Method 3 – Applying a Custom Format

Steps:

• Select the data range.
• Press Ctrl + 1 to get the Format Cells window.

• Choose the Custom option from the Number tab.
• Input 0% in the Type section.

• Press the OK button.

• Enter the Format Cells window.
• Change the Type to 0.00%.

• Here are the results.

### Method 4 – Using the CONCAT Function to Convert Numbers into Percentages

The CONCAT function is the updated form of the CONCATENATE function.

Steps:

• Add a new column on the right to show the result.

• Put the following formula in Cell D5.
=CONCAT(C5/0.01,"%")

• Press the Enter button and drag the Fill Handle icon.

### Method 5 – Convert Numbers to Percentages in an Excel Pivot Table

We have a dataset of each month’s profit of 2021 of a super shop. We will calculate the profit percentage for each month based on the total profit of the year.

Steps:

• Put the following formula in Cell D5.
=C5/SUM(\$C\$5:\$C\$16)

• Press the Enter button and drag the Fill Handle icon.

• Select the whole dataset.
• Click on the Pivot Table option from the Insert tab.

• A new window appears.
• Choose the Existing Worksheet option to place the Pivot table.
• Select a cell in the worksheet for the Location section.

• Press the OK button.
• The PivotTable Fields section appears.

• Tick the Month option and place it in the Rows field.
• Tick the Profit Percentage option and place it in the Values field.

• The results are in decimal form.

• Go to the Sum of Profit Percentage cell and right-click.
• Choose Value Field Settings from the Context Menu.

• The Value Filed Settings window appears.
• Choose the Show Values As option.
• Click on the drop-down.
• Choose the % of Column Total option.

• Press the OK button.

## How Do I Remove the Percentage Symbol in Excel Without Changing Values?

We have the following dataset. We’ll change the percentages to numbers without the percentage sign, but keep their value (so 30% becomes 30).

Steps:

• Go to Cell D5 and insert the following formula.
=VALUE(LEFT(TEXT(C5,"00.00%"),LEN(C5)-1))

• Press the Enter button and drag the Fill Handle icon.

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

## Related Articles

<<Go Back to Calculating Percentages in Excel

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF