The quickest way to flip negative numbers to positive

To change a negative number to positive in Excel, the simplest method is to multiply by -1. Select the cell with the negative number, type =A1*-1 (replacing A1 with your cell reference), and press Enter. The result appears in a new cell as a positive number. If you want to replace the original negative numbers instead, you can use Find & Replace to remove the minus sign directly from the cells.

Which method you choose depends on whether you need to keep the original numbers or overwrite them, and whether you're working with a single cell or a large column of data. Both approaches take less than a minute to set up.

Key Takeaways

  • Multiplying by -1 in a formula is the safest way to convert negatives to positives because it leaves your original data untouched.
  • Find & Replace can remove the minus sign directly from cells, which is faster for large datasets but overwrites the original numbers.
  • The ABS function returns the absolute value (positive version) of any number, whether negative or positive.
  • You can format negative numbers to display as positive without changing the actual values, useful when the underlying data must stay negative for calculations.

Using multiplication to convert negatives to positives

Create a formula in an empty column next to your negative numbers. In the first empty cell, type =A1*-1 (where A1 is the cell containing your negative number). Press Enter. The cell now shows the positive version of that number.

To explore this formula to all rows at once, click the cell with your formula, then drag the small square in the bottom-right corner of the cell down to the last row of data. Excel copies the formula down and adjusts the cell reference automatically. You now have a column of positive numbers alongside your original negatives.

If you want to keep only the positive numbers and delete the original column, copy the positive column, right-click, select Paste Special, click Values, and click OK. This converts the formulas to actual numbers so they stay positive even if you delete the original column.

Using Find & Replace to remove the minus sign

This method works directly on your cells without creating a new column. Select all the cells containing negative numbers. 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. Click Replace All.

Excel removes every minus sign from the selected cells, turning them positive. This is fast for large datasets, but it permanently changes your original data. If you might need the negative numbers later, save a copy of your spreadsheet first or use the multiplication method instead.

The ABS function for absolute values

The ABS function returns the absolute value of a number—its positive version, regardless of whether it started negative or positive. Type =ABS(A1) in an empty cell to convert the number in A1 to positive. Like the multiplication method, you can drag this formula down to explore it to multiple rows.

ABS is useful when you're working with mixed data (some negative, some already positive) and want all results to be positive. It's also clearer to read in a formula than multiplying by -1, so other people looking at your spreadsheet will understand what you're doing when ready.

Formatting negative numbers to look positive without changing them

Sometimes you need the numbers to stay negative for calculations elsewhere in your spreadsheet, but you want them to display as positive on a report or printout. Select the cells with negative numbers. Right-click and choose Format Cells. Click the Numbers tab. In the Category list on the left, click Number. In the "Negative numbers" section, choose a format that displays negatives without the minus sign (some formats show them in red or in parentheses instead).

This changes only how the numbers appear on screen or in print—the actual values remain negative. If you copy these cells and paste them elsewhere, they will still be negative. This approach is useful when you need to preserve the original data for formulas but show a different version to readers.

Choosing the right method for your situation

Use multiplication by -1 or ABS when you need to create a new column of positive numbers and keep your original data safe. These methods are reversible: you can always delete the new column and start over if you make a mistake.

Use Find & Replace when you have a large dataset, you're certain you want the numbers to be permanently positive, and you've already backed up your file. This method is the fastest for hundreds or thousands of rows.

Use formatting only when the underlying numbers must stay negative for other calculations, but you want them to look positive in a specific view or report. This is common in accounting, where negative numbers often represent credits or reductions that need to stay negative in formulas.

Frequently Asked Questions

Can I undo Find & Replace if I change my mind?

Yes, when ready after using Find & Replace, press Ctrl+Z (or Cmd+Z on Mac) to undo. Excel will restore the minus signs. If you've closed the file and reopened it, the undo history is gone, so the change is permanent. Always save a backup before using Find & Replace on important data.

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

ABS returns the positive version of any number, whether it's already positive or negative. Multiplying by -1 flips the sign: positive becomes negative, negative becomes positive. For converting negatives to positives, both work the same way. ABS is clearer to read in a formula.

If I use a formula to convert negatives, do the results stay positive if I delete the original column?

Only if you convert the formulas to values first. Select the column with formulas, copy it, right-click, choose Paste Special, click Values, and click OK. Now the cells contain numbers instead of formulas, so they stay positive even after you delete the original column.

Can I convert negatives to positives in multiple columns at once?

Yes. Select all the cells you want to convert, then use Find & Replace to remove all minus signs at once. Or create a formula in one cell, copy it, select the range where you want it to appear, and paste. Excel applies the formula to every cell in the selection.