How to☝️ Remove the Percentage in Excel

To remove the percentage from your data in Microsoft Excel, select the data, navigate to the Home tab, click the small arrow beside the Number format, and choose General for the format style.

In this article, you’ll learn a variety of ways to remove percentages from numbers in your data. It can take just a few seconds if you follow one of the methods below!

Method 1: Using the Home Tab

Difficulty: Beginner

Time Estimate: 5 Seconds

1. Select your data (A1:A5).

2. Go to the Home tab.

3. Click on the small arrow beside the Number format.

4. Pick the General option.

Using the Home Tab

And there you go! The percentages have been removed.

Removed percentages

Method 2: Using Custom Formatting

Difficulty: Beginner

Time Estimate: 15 Seconds

1. Select the data written as a percentage (A1:A5).

2. Right-click on the selected values.

3. Pick Format Cells.

Using Custom Formatting

4. Choose the Custom category.

5. Select 0.00% as the type.

6. Press Ctrl+J between 0.00 and %.

7. Click OK.

Custom category

8. Again select your data (A1:A5). 

9. Navigate to the Home menu.

10. Click on the Wrap Text option.

Wrap Text option

Easy as ABC! You have successfully removed the percentage.

Numbers

Method 3: Using Formulas

Difficulty: Beginner

Time Estimate: 15 Seconds

1. Click on the cell where you need to get the result.

2. Go to the Formula bar and type =VALUE(LEFT(TEXT(A1,”000.0000%”), 25)), where A1 is the cell with your percentage value, and 25 is the number from which you want to remove the percentage.

Using Formulas

3. Press the Enter key on your keyboard.

4. Drag the cell downward to copy the formula for the rest of the list.

Percentage

Voila! Let’s move on.

Method 4: Using VBA

Difficulty: Beginner

Time Estimate: 40 Seconds

1. Go to the Developer tab.

2. Pick the Visual Basic option.

Using VBA

3. Click Insert.

4. Choose the Module option.

5. Enter the following code:

 Sub remove_percentage()

Dim rng, cell As Range

Set rng = Range(“A1:A5”)

For Each cell In rng

 cell.NumberFormat = “General”

 cell = cell.Value * 100

Next

End Sub

Module option

6. Click the Run tab.

7. Tap the Run Sub/UserForm option.

Run SubUserForm option

Piece of cake!

The numbers

Method 5: Using Power Query

Difficulty: Beginner

Time Estimate: 1 Minute

1. Navigate to the Data tab.

2. Click From Table/Range.

Using Power Query

3. Set the range (the cells with your data).

4. Hit OK.

Table Range

5. Click on the Add Column menu.

6. Select Custom Column.

Custom Column

7. Enter the formula =Number.Round([Percentage]*100,2,RoundingMode.Up) in the Formula box.

8. Click OK.

Custom Column menu

9. Go to the Home tab.

10. Choose Close & Load.

11. Pick Close & Load To from the list.

Close & Load To

12. Choose the location where you want to import the data.

13. Click OK.

Import Data

That’s it! You have done it!

Column 1

Percentage FAQs

We suggest reading through the questions and answers below to better grasp this subject.

Why are percentages important?

Percentages are important because they help you understand the data that you are working with. They also help you see how much of a change there is in the data over time.

What are the rules for percentages?

To calculate a percentage, you first need to know the basic rules for percentages. A percent is simply a ratio or fraction with 100 as its denominator (base). So, if you have 50% of something, that means you have 50/100 or 1/2 of it. To find the percentage of something, you need to multiply the number by the decimal form of the percent (e.g., 70% = 0.70). 

Why are percentages reversible?

As you probably know, percentages are a way to express a number as a part of 100. What you may not know is that this relationship is actually reversible: if you have the percentage, you can find the original number, and if you have the original number, you can find the percentage. 

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X