The fastest way to flip negative values to positive

The quickest method is to use the ABS function, which strips the negative sign from any number. Type =ABS(A1) in a new column, replace A1 with the cell containing your negative number, and press Enter. Excel will show the positive version. If you have 100 negative values, copy this formula down the entire column and you're done in seconds.

If you want to replace the original negative numbers instead of creating a new column, copy the ABS results, then paste them back as values only (using Paste Special) over the original cells. This overwrites the negatives permanently.

A second approach works if you need to flip the sign of numbers that are already a mix of positive and negative: multiply the entire column by -1. Select all the cells, type -1 in an empty cell, copy it, then right-click your selection and choose Paste Special. Under Operation, select Multiply. Every negative becomes positive and every positive becomes negative.

Key Takeaways

  • The ABS function removes the negative sign from any number: type =ABS(cell) and press Enter.
  • Copy the ABS results and paste them as values to replace your original negative numbers permanently.
  • Use Paste Special with Multiply by -1 to flip the sign of an entire column at once, turning negatives to positives and positives to negatives.
  • ABS works on single cells, ranges, or formulas — you can nest it inside other calculations if you need the positive value as part of a larger equation.

Using ABS in a formula instead of a new column

You don't always need to create a separate column. If you're building a calculation that needs positive numbers, wrap ABS around the cell reference. For example, if column A holds expenses (some negative, some positive) and you want to sum their absolute values, type =SUM(ABS(A1:A100)). This adds up all the numbers as if they were positive, without changing the original data.

The same approach works in any formula: =ABS(A1)+B1, =ABS(A1)*0.1, or =IF(A1<0,ABS(A1),A1). ABS is just a function that returns the positive version of whatever number you feed it, so you can use it anywhere a number would go.

When to use Find and Replace instead

If your negative numbers are stored as text (which happens when data is imported from some systems), ABS won't work. You'll see an error or a zero. In that case, use Find and Replace to remove the minus sign directly. Press Ctrl+H (or Cmd+H on Mac), type - in the Find field, leave the Replace field empty, and click Replace All.

This method is crude — it removes every minus sign in your selection, so use it only on a column you've already isolated. It's also useful if you have negative numbers formatted with parentheses instead of a minus sign, like (500) for negative 500. In that case, find ( and ) separately and replace them with nothing.

Handling negative numbers formatted as text or currency

Sometimes Excel treats negative numbers as text, especially if they came from another program or were typed in with a leading apostrophe. ABS will fail silently or return an error. To fix this, convert them to real numbers first. Select the column, go to Data > Text to Columns, click Next twice, and click Finish. Excel will re-parse the cells as numbers.

If your negatives are formatted as currency (like -$500.00), ABS still works — the dollar sign and decimal places don't interfere. But if the minus sign is hidden inside the formatting (parentheses instead of a minus), you may need to change the cell format first. Right-click the cells, choose Format Cells, and switch to a number format that shows the minus sign clearly. Then ABS will recognize it.

Using a helper column to preserve your original data

If you want to keep the original negative numbers and also have a positive version, create a helper column. Put your ABS formula in column B while your original data stays in column A. This way you can always go back to the original if you need it, and you can compare the two side by side.

Once you've verified the positive numbers are correct, you can delete column A if you no longer need it. Or keep both columns if your spreadsheet needs to show both the original value and its absolute value — for example, a budget that tracks both expenses (negative) and their magnitude (positive).

Converting formulas to values when you're done

If you've used ABS or any other formula to create positive numbers, those cells still contain formulas, not fixed values. If you delete or move the original data, the formulas break. To lock in the positive numbers permanently, select the cells with formulas, copy them, right-click, choose Paste Special, and select Values Only. Now they're plain numbers, not formulas.

This step is straightforward to forget but important if you're cleaning up a spreadsheet or sending it to someone else. They won't see the formula bar change, but the cells will no longer depend on other cells to exist.

Frequently Asked Questions

Can I use ABS on a whole column at once?

Yes. Create the formula in one cell, then copy it down as far as you need. Click the cell with =ABS(A1), copy it, select the range where you want it (like B1:B1000), and paste. Excel adjusts the cell reference automatically for each row.

What if some of my numbers are already positive?

ABS leaves positive numbers alone — it only removes the negative sign. So if A1 is 500, =ABS(A1) returns 500. If A1 is -500, =ABS(A1) returns 500. You can safely run ABS on a mixed column without breaking the positive values.

Does ABS work in Google Sheets?

Yes, exactly the same way. Type =ABS(A1) in Google Sheets and it works identically. The Paste Special method also works, though the menu path is slightly different — go to Edit > Paste Special instead of right-clicking.

How do I undo a Find and Replace that removed minus signs?

Press Ctrl+Z (or Cmd+Z on Mac) when ready after. If you've already closed the file, you can't undo. This is why it's safer to use ABS — it doesn't change your original data unless you explicitly paste over it.

What if I want to flip positive numbers to negative instead?

Use =ABS(A1)*-1 to turn any number into its opposite sign. Or use the Paste Special Multiply by -1 method described above — it flips all signs in a selection at once, so positives become negative and negatives become positive.