The fastest way to flip negative numbers to positive

To change a negative number to positive in Excel, multiply the column by -1. Select an empty cell next to your data, type the formula =A1*-1 (replacing A1 with your cell reference), press Enter, then copy the formula down for all rows. You can then copy these results and paste them back as values to replace the original negative numbers.

If you have only a few negative numbers scattered throughout your spreadsheet, you can also select each cell individually and delete the minus sign by hand, or use Find & Replace to remove all minus signs at once. The method you choose depends on how many numbers you need to change and whether you want to keep a record of the original values.

Key Takeaways

  • Multiplying by -1 is the most reliable method because it works on entire columns at once and leaves no formatting issues behind.
  • The ABS function returns the absolute value of a number, removing the negative sign without creating a new formula column.
  • Find & Replace can remove all minus signs in seconds if your negative numbers are the only ones in a specific range.
  • Pasting results as values replaces your original data, so copy your spreadsheet first if you need to keep the negative numbers.

Using the multiply-by-negative-one method

This is the most straightforward approach for converting an entire column. Click on an empty column next to your data — say column B if your numbers are in column A. In the first cell of that empty column, type =A1*-1 and press Enter. Excel multiplies the value in A1 by -1, flipping its sign.

Now copy that formula down to match all your data. Click the cell with your formula, then drag the small square at the bottom-right corner of the cell down to the last row with data. Excel automatically adjusts the cell reference for each row, so A1 becomes A2, A3, and so on. You now have all your positive numbers in column B.

To replace your original negative numbers, select all the new positive values in column B, copy them, then right-click on column A and choose Paste Special. Click Values and then OK. This pastes only the numbers, not the formulas, into column A. You can then delete column B.

Using the ABS function for a single formula

The ABS function returns the absolute value of a number — the number without its sign. Type =ABS(A1) in an empty cell and press Enter. This gives you the positive version of whatever number is in A1, whether it was negative or positive to begin with.

Like the multiply method, copy this formula down your entire column, then use Paste Special to convert the formulas to values if you want to replace your original data. ABS is useful when you want a single, clean formula that makes your intent obvious to anyone reading your spreadsheet later.

Removing minus signs with Find & Replace

If your negative numbers are clustered in one area and you want to change them in place without creating a helper column, use Find & Replace. Select the range of cells containing your negative numbers. Press Ctrl+H (or Cmd+H on Mac) to open the Find & Replace dialog.

In the Find what field, type a minus sign: -. Leave the Replace with field empty. Click Replace All. Excel removes every minus sign from your selected range, turning all negative numbers positive when ready. This method is fast but offers no undo for individual cells — if you make a mistake, press Ctrl+Z when ready to revert.

Handling mixed positive and negative data

If your column contains both positive and negative numbers and you only want to flip the negative ones, the multiply and ABS methods will change everything. Instead, use Find & Replace on just the cells you need, or create a formula that checks the sign first.

For a conditional approach, type =IF(A1<0,A1*-1,A1) in an empty cell. This formula checks whether A1 is less than zero. If it is, it multiplies by -1. If it is not, it leaves the number alone. Copy this formula down your column, then paste the results back as values. This preserves your positive numbers while flipping only the negative ones.

Avoiding common mistakes

The most common error is forgetting to paste results as values before deleting your helper column. If you delete the column with your formulas before converting them to plain numbers, Excel will show #REF! errors in the cells where you pasted. Always copy, paste as values, then delete — in that order.

Another mistake is using Find & Replace on your entire spreadsheet when you meant to use it on one column. This can accidentally remove minus signs from dates, account numbers, or other data where the minus sign matters. Always select your target range first, then open Find & Replace.

When to keep the original negative numbers

If you need to preserve your original data for auditing or reference, do not overwrite column A. Instead, keep your helper column with the positive numbers, or save a copy of your spreadsheet before making changes. Many accounting workflows require a record of the original values, so check your organization's standards before converting.

You can also add a note in a nearby cell explaining what you changed and when. This helps anyone else using the spreadsheet understand why the numbers look different from the source document.

Frequently Asked Questions

Can I change negative numbers to positive without creating a new column?

Yes, using Find & Replace removes all minus signs in place. Select your range, press Ctrl+H, search for a minus sign, leave the replace field empty, and click Replace All. This works when ready but cannot be undone for individual cells.

What is the difference between multiplying by -1 and using ABS?

Both produce the same result for negative numbers. ABS is clearer to read in a formula, while multiplying by -1 is slightly faster to type. Choose whichever feels more natural to you — the outcome is identical.

Will changing negative to positive affect my formulas that reference these cells?

Yes. If other cells contain formulas that reference the numbers you change, those formulas will now use the positive values instead. Check your spreadsheet for dependent formulas before converting, or test on a copy first.

How do I change only some negative numbers, not all of them?

Use the conditional formula =IF(A1<0,A1*-1,A1) to flip only negative values while leaving positive ones unchanged. Copy this down your column, then paste as values to replace the original data.

What if I accidentally deleted my original data?

Press Ctrl+Z when ready to undo. Excel's undo history goes back many steps, so you can usually recover recent changes. If you have already closed the file, the original data is lost — this is why saving a backup before major changes is important.