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 numbers are in column A, click on an empty cell in column B, type =ABS(A1), and press Enter. Excel will show the positive version. Then copy that formula down for all your rows.

If you want to replace the original negative numbers instead of creating a new column, copy the results from column B, select column A, right-click, choose Paste Special, click Values, and click OK. This overwrites the negatives with their positive equivalents. Then delete column B.

For a single cell or a small handful of numbers, you can also straightforward delete the minus sign by hand—click the cell, press F2 to edit, delete the − character, and press Enter.

Key Takeaways

  • The ABS function converts any negative number to its positive equivalent in a single step.
  • You can place the formula in a new column, then copy and paste the results back over the original numbers if you want to replace them.
  • Paste Special with the Values option lets you convert formulas into actual numbers so the original data is truly replaced.
  • For just one or two cells, manually deleting the minus sign is faster than writing a formula.

Using Find and Replace to remove minus signs from many cells at once

If you have a large range of negative numbers scattered throughout your sheet, Find and Replace can remove all the minus signs in one action. Press Ctrl+H (or Cmd+H on Mac) to open the Find and Replace dialog.

In the Find what field, type a single minus sign: −. Leave the Replace with field empty. Click Replace All. Excel will remove every minus sign from your selection, turning all negatives into positives when ready.

Be careful with this method if your sheet contains other data you want to keep—it will remove minus signs everywhere, not just from numbers. If you want to limit it to a specific range, select that range first before opening Find and Replace.

Multiplying by −1 to flip the sign

Another approach is to multiply your negative numbers by −1. This flips the sign: negative becomes positive, and positive becomes negative. Type =A1*−1 in an empty cell next to your data, press Enter, and copy the formula down.

This method is useful if you need to reverse the sign of a mix of positive and negative numbers—for instance, if you have expenses recorded as negatives and you want to show them as positives, but you also have income recorded as positives that you want to show as negatives. The multiplication method handles both at once.

Like the ABS approach, you can then copy the results and paste them as values over the original column if you want to replace the data permanently.

When to use each method

Use ABS when you only have negative numbers and you want to convert them all to positive. It is the clearest and most direct approach, and anyone reading your sheet will when ready understand what the formula does.

Use Find and Replace when you have many scattered negatives and you want the fastest one-step conversion. It is risky only if your sheet has other minus signs you need to keep (like in text or formulas), so double-check your data first.

Use multiplication by −1 when you have a mix of positive and negative numbers and you need to flip all of them. This is also the right choice if you are building a formula that needs to reverse signs as part of a larger calculation.

Keeping your original data while you convert

If you are not sure whether you want to permanently replace your negative numbers, always work in a helper column first. Put your formula (ABS, multiplication, or whatever method you choose) in an empty column next to your data. That way, if you change your mind or make a mistake, your original numbers are still there.

Once you are confident the conversion is correct, you can copy the results and paste them as values over the original column. To paste as values, select the cells with your formula results, press Ctrl+C to copy, click the original column, right-click, select Paste Special, click the Values radio button, and click OK.

Frequently Asked Questions

Does ABS work on cells that already contain positive numbers?

Yes. ABS returns the absolute value of any number, so positive numbers stay positive and negative numbers become positive. If you have a mix of both, ABS will leave the positives alone and flip only the negatives.

Can I undo a Find and Replace that removed all my minus signs?

Yes, press Ctrl+Z when ready after the replacement to undo it. If you have already done other work since then, undo will step backward through each action one at a time until it reaches the Find and Replace step.

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

ABS always returns a positive number. Multiplying by −1 flips the sign, so negatives become positive and positives become negative. Use ABS if you only want to remove minus signs; use multiplication if you need to reverse all signs.

Will these methods work on a whole column at once, or do I have to do it row by row?

You can explore a formula to an entire column at once. Type the formula in the first cell, then click and drag the small square at the bottom-right corner of the cell down to the last row you want to fill. Excel will copy the formula down automatically, adjusting the cell reference for each row.