The fastest way to flip negative numbers to positive

The quickest method is to use the ABS function, which returns the absolute value of a number — the number without its sign. If your negative numbers are in column A, click on an empty column (say, column B), type =ABS(A1) in the first cell, then drag that formula down to cover all your rows. Excel will convert -50 to 50, -1200 to 1200, and so on.

If you want to replace the original negative numbers instead of creating a new column, copy the results from column B, then paste them back into column A using Paste Special. Right-click column A, choose Paste Special, select Values, and click OK. Then delete column B. This overwrites your original data with the positive versions.

For a single cell or a small handful of numbers, you can also type the number without the minus sign directly into the cell. But the ABS function is faster when you have dozens or hundreds of rows, because it does the work all at once.

Key Takeaways

  • The ABS function removes the negative sign from any number: type =ABS(A1) in a new column and drag down to convert all negatives at once.
  • If you want to keep only the positive numbers and delete the original column, copy the ABS results and paste them back as values, then delete the helper column.
  • Find and Replace can swap minus signs for nothing, but only if your negatives are formatted as text rather than actual numbers.
  • Multiplying by -1 flips the sign of every number, turning negatives to positives and positives to negatives — useful if you need the opposite effect.

Using Find and Replace for text-formatted negatives

If your negative numbers are stored as text (which happens when data is imported from certain systems), the ABS function may not work. In that case, use Find and Replace. Press Ctrl+H (or Cmd+H on Mac), type a minus sign - in the Find field, leave the Replace field empty, and click Replace All. This removes every minus sign from your selection.

Before you do this, select only the cells you want to change. If you replace across the entire sheet, you might accidentally remove minus signs from other data you want to keep. After replacing, you may need to convert the text back to numbers: select the column, go to Data menu, choose Text to Columns, and click Finish. Excel will recognize them as numbers again.

Flipping signs with multiplication

If you need to turn positives into negatives and negatives into positives at the same time, multiply by -1. In an empty column, type =-1*A1, then drag down. This flips every sign: 50 becomes -50, and -50 becomes 50.

This is useful when you're working with financial data where a negative number represents income and you need it to show as a positive expense, or vice versa. After you have the flipped numbers, you can copy and paste them back as values the same way you would with ABS.

Handling mixed positive and negative data

Sometimes a spreadsheet has both positive and negative numbers, and you only want to change the negatives. The ABS function will turn all of them positive, which might not be what you need. In that case, use an IF statement: =IF(A1<0,-A1,A1). This checks if the number is less than zero; if it is, it multiplies by -1 to flip it; if it is not, it leaves it alone.

Type this formula in a new column, drag it down, then copy and paste the results back as values if you want to replace the original data. This preserves your positive numbers while converting only the negatives.

Formatting negatives to look positive without changing the data

Sometimes you do not actually need to change the numbers themselves — you just need them to display differently. Excel's number formatting can show negative numbers without a minus sign. Select the cells with negative numbers, right-click, and choose Format Cells. Under the Number tab, find a format that shows negatives in parentheses or in red, or create a custom format that hides the minus sign entirely.

This approach is useful for reports where you want negatives to look different but you need to keep the original data intact for calculations. The underlying numbers stay negative; only the display changes. If you later copy these cells into another sheet or program, they will still be negative.

Checking your work after conversion

After you convert negative numbers to positive, spot-check a few cells to make sure the conversion worked. Look at the original data and the new data side by side. If you used ABS or multiplication, the numbers should match except for the sign. If you used Find and Replace on text, make sure no other minus signs were accidentally removed from cells nearby.

If something went wrong, press Ctrl+Z (or Cmd+Z on Mac) to undo. Excel remembers your last several actions, so you can step back as many times as you need. Once you are confident the conversion is correct, you can delete the helper column or save the file.

Frequently Asked Questions

Will ABS change my original numbers or create new ones?

ABS creates new numbers in whatever column you put the formula in. Your original data stays unchanged. If you want to replace the original numbers, copy the ABS results and paste them back as values, then delete the original column.

What is the difference between ABS and multiplying by -1?

ABS removes the negative sign from negative numbers and leaves positive numbers alone. Multiplying by -1 flips every sign: negatives become positive and positives become negative. Use ABS if you only want to remove minus signs; use multiplication if you need to flip all signs.

Can I undo a conversion if I make a mistake?

Yes. Press Ctrl+Z (or Cmd+Z on Mac) when ready after the conversion to undo. Excel keeps a history of your recent actions, so you can step back multiple times if needed. If you closed the file, you cannot undo.

Why does Find and Replace not work on my negative numbers?

Find and Replace works on text, not on actual numbers. If your negatives are stored as real numbers in Excel, the ABS function or multiplication method will work better. If they are text, Find and Replace will remove the minus sign, but you may need to convert them back to numbers afterward using Text to Columns.