How to Remove – Sign in Excel: A Comprehensive Step-by-Step Guide

Removing a minus sign in Excel is a straightforward process that involves using simple formulas or the Find & Replace feature. You can quickly convert negative numbers to positive ones, making your data easier to read or use for calculations. Here, we’ll guide you through two methods to remove the minus sign from your data.

How to Remove a Minus Sign in Excel

In this section, you’ll learn two methods for removing the minus sign from data in Excel. Both methods are easy and efficient.

Step 1: Use the ABS Function

The ABS function in Excel converts negative numbers to positive ones.

Select the cell where you want the positive number to appear. Click on it to make it active.

Step 2: Enter the Formula

Type =ABS(A1) into the selected cell, replacing "A1" with the cell that contains the negative number.

Press Enter to apply the formula. The cell will now display the absolute value of the number, which is the number without the minus sign.

Step 3: Drag the Fill Handle

Click and drag the fill handle (a small square at the lower-right corner of the cell) down or across cells to apply the formula to other cells.

The ABS function will convert all negative numbers in the range to positive ones.

Step 4: Copy and Paste Values

Select the cells with the ABS formula, right-click, and choose "Copy." Then right-click on the destination cells and choose "Paste Special > Values."

This will replace the formulas with the actual positive numbers.

Step 5: Use Find & Replace

Alternatively, you can use Find & Replace to remove minus signs. Press Ctrl+H to open the Find & Replace dialog box.

In the "Find what" field, type a minus sign (-). Leave the "Replace with" field blank and click "Replace All."

After completing these actions, all the minus signs will be removed, and your data will consist of positive numbers.

Tips for Removing Minus Signs in Excel

  • Use the ABS function for quick conversions.
  • The Find & Replace method is useful for large datasets.
  • Always double-check your data after replacing values.
  • Save a backup of your original data before making changes.
  • Learn keyboard shortcuts for efficiency.

Frequently Asked Questions

How do I convert multiple columns at once?

You can drag the fill handle across multiple columns after applying the ABS function to the first cell.

What if I only want to remove specific minus signs?

Using Find & Replace allows you to selectively remove minus signs by specifying which cells to search.

Can I undo the changes if I make a mistake?

Yes, you can use the undo feature (Ctrl+Z) to revert any changes.

What happens if I leave negative numbers in my data?

Leaving negative numbers can affect calculations and data interpretation, so it’s crucial to manage them correctly.

Is there a way to automate this process?

Yes, you can use Excel macros to automate repetitive tasks like removing minus signs.


  1. Use the ABS Function.
  2. Enter the Formula.
  3. Drag the Fill Handle.
  4. Copy and Paste Values.
  5. Use Find & Replace.


Removing minus signs in Excel is a breeze once you know the right methods. By using the ABS function or the Find & Replace feature, you can quickly transform your data to meet your needs. Remember to double-check your work and save backups to avoid any mishaps. With these tips and techniques, you’ll be able to manage your Excel data like a pro, making your tasks more efficient and accurate. For more advanced techniques, consider exploring Excel tutorials or forums where you can learn new tricks to enhance your spreadsheet skills. Happy Excel-ing!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy