Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to remove negative sign from numbers in Excel?

When work on Excel worksheet, sometimes, we need to remove negative sign from the numbers for some calculations, that is to say we would like to convert the negative numbers to positives. To achieve this requirement, the following methods may help you.

Remove negative sign from numbers with ABS function

Remove negative sign from numbers with Find and Replace command

Remove negative sign from numbers with Kutools for Excel


Convert multiple negative values to positive ones at once:

Kutools for Excel's Change Sign of Values utility can help you to convert negative numbers to positive and vice versa, it also can help you to fix the trailing negative signs, change all negative numbers to zeros as you need.

doc remove negative sign 8 8

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!



To remove the negative sign from the numbers, here is a simple ABS function, please do as follows:

1. Please enter this formula: =ABS(A1) into a blank cell, and press Enter key, and the negative sign has been removed at once if the cell is a negative value, see screenshot:

doc remove negative sign 1

2. Then select cell F1 and drag the fill handle across to the range cells which you want to contain this formula, and all the negative signs have been removed from the negative numbers, see screenshot:

doc remove negative sign 2

3. And then you should copy and paste these formulas to another range you need as value.


In Excel, Find and Replace command also can help you to find the negative sign in a range and replace it with nothing and thus the number will become positive.

1. Select the range that you want to remove the negative sign.

2. Click Home > Find & Select > Replace, see screenshot:

doc remove negative sign 3

3. In the Find and Replace dialog, under the Replace tab, type the negative sign into the Find what text box, and type nothing to leave the Replace with text box blank. See screenshot:

doc remove negative sign 4

4. And then click Replace All button, all the negative signs have been removed at once, and the negative numbers have been converted to positives. See screenshot:

doc remove negative sign 5

5. Then click OK and close the Find and Replace dialog box.


If you have installed Kutools for Excel, its Change Sign of Values also may do you a favor. With this Change Sign of Values feature, you can finish the following operations as well:

After installing Kutools for Excel, please do as follows:

1. Select the data range that you want to remove the negative signs.

2. Click Kutools > Content > Change Sign of Values, see screenshot:

doc remove negative sign 6 6

3. In the Change Sign of Values dialog box, select Change all negative values to positive option, see screenshot:

doc remove negative sign 7

4. And then click Ok or Apply button, all negative numbers have been converted to positives, and the negative signs are removed as well.

Click to know more about this Change all negative values to positive feature.

Download and free trial Kutools for Excel Now !


Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 80% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    SC · 10 months ago
    Thanks for the find and replace tip - that's exactly what I needed to solve my problem.