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—meaning it strips away the negative sign and leaves you with the positive version. If your negative number is in cell A1, type =ABS(A1) in a new cell, and Excel will show the positive equivalent.

If you want to replace the original negative numbers rather than create a new column, copy the ABS results, then paste them back as values only. This overwrites the negatives with their positive counterparts in the same location.

For a single cell or a small handful of numbers, you can also multiply by -1: type =-1*A1 in a new cell. This flips the sign of whatever is in A1. Both methods work equally well; ABS is clearer when you're reading your own spreadsheet later.

Key Takeaways

  • The ABS function converts any negative number to its positive equivalent in a single step: =ABS(A1).
  • Multiplying by -1 also flips the sign, so =-1*A1 produces the same result as ABS.
  • To replace negatives in their original cells, create the formula in a new column, copy it, then paste as values back into the original column.
  • Find and Replace with a minus sign can remove negative signs from a large range without formulas, though it requires careful setup to avoid errors.

Using ABS to convert a whole column at once

If you have dozens or hundreds of negative numbers in one column, the ABS method scales easily. Click on the cell next to your first negative number, type =ABS(A1) (replacing A1 with your actual cell), then press Enter.

Now click that cell again and look for the small square in the bottom-right corner of the cell border—that is the fill handle. Double-click it, and Excel will copy the formula down to match however many rows of data you have. If double-clicking does not work, click and drag the fill handle down as far as your data extends.

You now have a new column of positive numbers. To move them back into the original column, select all the new positive values, copy them, right-click the original column, choose Paste Special, click Values, and click OK. This pastes only the numbers, not the formulas, so you can delete the helper column afterward.

Multiply by -1 for a simpler alternative

Instead of ABS, you can create a formula that multiplies each negative number by -1. In a new cell next to your first negative, type =-1*A1 and press Enter. The result is the positive version of that number.

This method works identically to ABS for negative numbers. The difference appears only if your column contains positive numbers: ABS leaves them positive, but multiplying by -1 flips them to negative. If your data is purely negative, either formula works fine. Use whichever feels more natural to you.

Using Find and Replace to remove minus signs

For a quick fix without formulas, you can use Find and Replace to strip out the minus sign directly. Select the range of cells containing negative numbers, then press Ctrl+H (or Cmd+H on Mac) to open Find and Replace.

In the Find what field, type a single minus sign: -. Leave the Replace with field empty. Click Replace All, and Excel removes every minus sign from your selection, leaving only the numbers.

This method is fast but risky if your range contains text or formulas that use minus signs for other purposes. Always check a few cells after replacing to make sure nothing unexpected changed. If something went wrong, press Ctrl+Z when ready to undo.

When to use each method

Use ABS when you want a formula you can copy down a column and when you might need to reference the original negatives later. The formula stays in place and updates automatically if the source data changes.

Use multiply by -1 when you prefer a straightforward formula or when you are working with just a few cells. It is equally reliable and slightly more obvious to someone reading your spreadsheet.

Use Find and Replace only when you are certain your range contains only numbers and no formulas, and when you want the change to happen when ready without a helper column. It is the fastest visual method but offers no undo if you catch an error after closing the file.

Pasting formulas as values to lock in the change

Whichever method you choose, if you want the positive numbers to stay in place even if the original data changes, you must convert the formulas to values. Select the cells containing your formula results, copy them, then right-click and choose Paste Special.

In the Paste Special dialog, click the Values radio button and click OK. Excel replaces the formulas with their results—the actual numbers. Now if the original column changes, these cells will not update. This is useful when you want a permanent record of the conversion.

Frequently Asked Questions

Will ABS change positive numbers to negative?

No. ABS returns the absolute value, which is always positive or zero. If you use =ABS(5), it stays 5. If you use =ABS(-5), it becomes 5. Positive numbers are unaffected.

Can I undo Find and Replace if I make a mistake?

Yes, but only if you have not closed the file. Press Ctrl+Z when ready after replacing. If you have closed and reopened the file, the undo history is gone. Always test Find and Replace on a small range first.

What if my column has both positive and negative numbers?

ABS will convert all of them to positive, which is usually what you want. If you need to keep some positive and flip only the negatives, you will need a more complex formula like =IF(A1<0,-A1,A1), which flips only negative values and leaves positives alone.

Do I have to create a helper column, or can I replace the original numbers?

You can replace them directly, but it requires an extra step. Create the formula in a helper column first, copy the results, then paste as values back into the original column. This ensures you do not lose your data if something goes wrong.

Which method is fastest for thousands of rows?

ABS with the fill handle double-click is fastest for large datasets. Type the formula once, double-click the fill handle, and it copies down when ready. Find and Replace is also fast but riskier. Multiply by -1 works just as well but requires the same steps as ABS.