The fastest way to flip negative to positive

To change a negative number to positive in Excel, multiply it by -1. Select the cell with the negative number, type =A1*-1 (replacing A1 with your cell reference) into an empty cell, and press Enter. The result appears as a positive number. If you have many negative numbers to convert, copy this formula down the column.

This method works because multiplying any negative number by -1 reverses its sign. A negative becomes positive, and a positive becomes negative. It's the simplest approach for one-off conversions or small batches.

Key Takeaways

  • Multiply a negative number by -1 in a formula to flip it to positive: =A1*-1
  • Use the ABS function to show only the positive value without changing the original data: =ABS(A1)
  • The Find & Replace method with a minus sign works for bulk conversions when you want to overwrite the original cells.
  • Paste Special with the multiply operation lets you convert many cells at once by multiplying them all by -1 in one step.

Using the ABS function to show positive values

The ABS function returns the absolute value of a number—the positive version without the minus sign. Type =ABS(A1) into an empty cell and press Enter. This is cleaner than multiplying by -1 if you only need to display the positive version for a report or calculation.

ABS is especially useful when you want to keep the original negative numbers intact in your source data but show positive values elsewhere. Copy the formula down to convert a whole column. The original cells stay negative; only the formula results show as positive.

Converting multiple cells with Paste Special

To flip many negative numbers to positive at once without creating a separate formula column, use Paste Special. First, click an empty cell and type -1, then press Enter. Right-click that cell and select Copy.

Next, select all the cells containing negative numbers you want to convert. Right-click and choose Paste Special. In the dialog box, make sure Multiply is selected under the Operation section, then click OK. Every selected cell multiplies by -1, flipping all negatives to positive in place.

This method overwrites your original data, so save a backup copy first if you need to keep the negative numbers. It's much faster than copying a formula down when you have hundreds of cells to convert.

Finding and replacing the minus sign

For a quick visual fix, you can remove the minus sign using Find & Replace, though this changes the actual data. Press Ctrl+H (or Cmd+H on Mac) to open Find & Replace. In the "Find what" field, type a single minus sign: -

Leave the "Replace with" field empty and click Replace All. Every minus sign in your selection disappears, and the numbers become positive. This method is risky because it treats all minus signs the same way—if you have formulas or other text with hyphens, they get affected too. Use it only on a column of pure numbers.

Choosing between methods: formula vs. permanent change

Decide whether you want to keep the original negative numbers or replace them permanently. If you need both versions—negative in one place, positive in another—use a formula like =ABS(A1) or =A1*-1 in a new column. This preserves your source data and lets you reference either version.

If you only need the positive version and want to save space, use Paste Special or Find & Replace to overwrite the cells. Paste Special is safer because it only affects the cells you select, while Find & Replace can catch unintended minus signs elsewhere in the sheet.

For one or two cells, a straightforward formula is fastest. For dozens or hundreds, Paste Special saves time and keeps your work clean.

Common mistakes to avoid

Don't forget to press Enter after typing a formula—the formula won't calculate until you do. If you copy a formula down a column, make sure the cell references update correctly. Excel usually does this automatically, but check the first few results to confirm.

When using Paste Special, remember that you're overwriting the original values. If you change your mind, press Ctrl+Z when ready to undo. Also, make sure Multiply is selected in the Paste Special dialog—if you leave it on Add or Subtract, you'll get the wrong result.

With Find & Replace, be cautious about scope. Select only the cells you want to change before opening the dialog, or use Find & Replace on the entire sheet only if you're certain no other minus signs should stay.

Frequently Asked Questions

Can I convert negative to positive and keep the original numbers too?

Yes. Use a formula like =ABS(A1) or =A1*-1 in a new column instead of overwriting the original cells. The formula column shows positive values while the original column stays negative. You can reference either version in other calculations.

What's the difference between ABS and multiplying by -1?

ABS always returns a positive number, even if the input is already positive. Multiplying by -1 flips the sign: negative becomes positive, positive becomes negative. Use ABS when you only want positive results. Use multiplication by -1 when you want to reverse the sign of any number.

Will these methods work on cells with formulas inside them?

Yes, but the result depends on the method. If you use Paste Special multiply on a cell containing a formula, Excel multiplies the formula's result by -1. If you use Find & Replace on a formula cell, it removes the minus sign from the formula text itself, which may break the formula. Formulas are safer with Paste Special.

How do I undo a change if I converted the wrong cells?

Press Ctrl+Z when ready after the conversion to undo. This works for Paste Special, Find & Replace, and formulas. If you've saved the file, undo won't work—you'll need to reopen the previous version or manually fix the cells.

Can I convert negative numbers in a pivot table or chart?

Pivot tables and charts pull data from source cells, so convert the source data first using one of these methods. The pivot table or chart updates automatically. You can also format the display to show negative numbers as positive without changing the underlying data, but that's a formatting choice, not a true conversion.