How to Remove Percentage in Excel (5 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

In an Excel sheet, you can use different kinds of formats based on your need. Percentage is one of the Number Format which is used to show a relative value that indicates the 100th part of any quantity. But sometimes you may need to remove the percentage while keeping the value as it is or you need the decimal value. In this article, I’m going to explain, how to remove percentage in Excel.

For the demonstration purpose, I’m going to use a dataset that contains information about an employee. The dataset has 4 columns; these are Employee Name, Salary, Bonus, and Percentage.

. Sample Dataset to Remove Percentage in Excel

Here, I calculated the Percentage dividing Bonus by Salary.


Download to Practice


5 Ways to Remove Percentage in Excel

1. Remove Percentage Using General Format in Excel

One of the easiest ways to remove percentages is using the General format but the problem is it converts the percentage values into decimal points.

Let me show you the procedure,

To begin with, select the cell or cell range from where you want to remove the percentage.

➤ I selected the cell range E4:E11.

Open the Home tab >> from Number Format >> select General

1. Remove Percentage Using General Format in Excel

Hence, you will get the Percentage values in General format without a percentage sign. 

Read More: How to Remove Percentage Symbol in Excel (4 Ways)


2. Remove Percentage Using Number Format

Another way to remove percentages is by using the Number format.

To start with, select the cell or cell range from which you want to remove the percentage.

➤ I selected the cell range E4:E11.

Open the Home tab >> from Number Format >> select Number

Remove Percentage Using Number Format in Excel

As a result, the Percentage values are formatted as Numbers while ignoring the sign.

Read More: How to Remove Number Error in Excel (3 Ways)


3. Remove Percentage Using Paste Special in Excel

To keep the percentage values and to remove the percentage sign you can use the Paste Special.

To demonstrate the procedure, I’ve taken an additional column where I kept the values 100. As I want to remove the percentage sign so, I’ll need to multiply the value by 100.

The logic behind this is, (5.00/100)*100

Remove Percentage Using Paste Special in Excel

To begin with, select the cell where you kept the value 100.

➤ I selected cell G4.

Then, right click on the mouse and select Copy from the context menu.

You can also use CTRL + C to copy the value.

Now, select the cell or cell range from where you want to remove the percentage sign and keep the value as it is.

➤ I selected the cell range E4:E11.

Remove Percentage Using Paste Special in Excel

Again, right click on the mouse and double click on Paste Special from the context menu.

A dialog box will pop up. From there select the Operation.

⏩ I selected  Multiply.

Then, click OK.

Remove Percentage Using Paste Special in Excel

Hence, it will remove the Percentage sign but the value will remain the same.

Read More: How to Remove Error in Excel (8 Methods)


Similar Readings


4. Remove Percentage Using Custom Format

By using the Custom format and Wrap Text you can keep the percentage values while removing or hiding the sign.

Let me show you the procedure,

To begin with, select the cell or cell range from where you want to remove the percentage sign while keeping the value.

➤ I selected the cell range E4:E11.

Open the Home tab >> from Number Format >> select More Number Formats

Remove Percentage Using Custom Format in Excel

A dialog box will pop up. From there select Category.

⏩ I selected Custom.

Then, selected 0.00% as the Type.

Now, place the cursor before the percentage and press CTRL + J.

CTRL + J will create a new line. 

Here, the percentage is removed from Type then click OK.

Remove Percentage Using Custom Format in Excel

Now, select the cell range to apply Wrap Text. 

➤ I selected the cell range E4:E11.

Open the Home tab >> from Alignment >> select Wrap Text

Hence, it will apply Wrap Text to the selected cell.

As I don’t want the percentage sign so I will hide the line where the percentage is.

To do that, I will decrease the Row Height.

At first, select the cell or cell range from where you want to remove the percentage sign.

➤ I selected the cell range E4:E11.

Open the Home tab >> go to Cells >> from Format >> select Row Height

Remove Percentage Using Custom Format in Excel

➤ I inserted the height as 16.

Then, click OK.

Therefore, it will hide the percentage sign only the values will be visible.

Remove Percentage Using Custom Format in Excel

Read More: How to Remove Formatting in Excel Without Removing Contents


5. Using Power Query to Remove Percentage in Excel

You also can use the Power Query to remove percentages while keeping the same value.

To start with, select the cell range

➤ I selected the cell range B3:B11.

Open the Data tab >> select From Table/Range

Using Power Query to Remove Percentage in Excel

A dialog box will pop up. It will show the selected range.

Mark on My table has headers.

Then click OK.

A new window will appear.

Using Power Query to Remove Percentage in Excel

From Add Column tab >> select Custom Column

A dialog box of Custom Column will appear.

⏩ In the New column name I used Percentage Value.

⏩ In the Custom column formula I used [ Percentage ]*100.

Then, click OK.

Using Power Query to Remove Percentage in Excel

Hence, it will add a new column name Percentage Value showing the values.

In case you want to load the table in the worksheet you can do it.

Open Home tab >> from Close & Load >> select Close & Load To…

Using Power Query to Remove Percentage in Excel

A dialog box will pop up. From there you can choose the place to put the data.

⏩ I selected New worksheet.

Then, click OK.

Therefore, it will import the data in a new worksheet.

Using Power Query to Remove Percentage in Excel

Related Content: How to Remove Partial Data from Multiple Cells in Excel (6 Ways)


Practice Section

I’ve provided a practice sheet in the workbook to practice these explained examples.


Conclusion

In this article, I have shown 5 ways to remove percentage in Excel. These ways will help you to remove percentages easily. Feel free to comment down below for any types of queries and suggestions.


Related Articles

Shamima Sultana

Shamima Sultana

Hello! Welcome to my Profile. I am Shamima Sultana Rita. Currently, I'm working as a Project Manager at ExcelDemy. I am doing research on Microsoft Excel and here we will be posting articles related to this. My last educational degree was BSc and my program was in Computer Science and Engineering from East West University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. I love to learn new things. Data Analysis is one of my favorite fields as I love to extract patterns based on problems. Here, I'm trying to provide enriched quality content regarding Excel basics to Advanced. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo