The fastest way to flip negative values 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 (say B1), type =ABS(A1), and press Enter. Excel will show the positive version. Then copy that formula down for every row that contains a negative number.

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 negative numbers with their positive equivalents. Then delete column B.

For a single cell or a small handful of numbers, you can also straightforward type the positive version directly—but the ABS function saves time when you have dozens or hundreds of values to convert.

Key Takeaways

  • The ABS function converts any negative number to its positive equivalent in a single step: type =ABS(cell) in an empty cell and press Enter.
  • Copy the ABS formula down to convert an entire column of negative numbers at once.
  • Use Paste Special > Values to replace your original negative numbers with the positive results, then delete the helper column.
  • If you only have one or two negative values, typing the positive number directly is faster than using a formula.
  • The ABS function works on individual cells, ranges, or entire columns—it scales to whatever size your data is.

Step-by-step: converting a column of negative numbers

Start by opening your spreadsheet and locating the column with negative values. In this example, assume your negative numbers are in column A, rows 1 through 10.

Click on cell B1 (the cell directly to the right of your first negative number). Type =ABS(A1) and press Enter. Excel calculates the absolute value and displays the positive result in B1.

Now click on B1 again to select it. You will see a small square in the bottom-right corner of the cell—this is the fill handle. Click and drag it down to B10 to copy the formula to all rows. Excel automatically adjusts the cell reference for each row (A2, A3, A4, and so on), so each formula points to the correct negative number.

At this point, column B contains all your positive values, but column A still has the negatives. To replace the originals, select all the cells in column B that now contain positive numbers (B1:B10). Press Ctrl+C (or Cmd+C on Mac) to copy them.

Click on cell A1, then right-click and select Paste Special. A dialog box opens. Click the Values radio button and click OK. Excel pastes only the numbers (not the formulas) into column A, replacing the negatives with positives. You can now delete column B since you no longer need it.

Using Find and Replace for a different approach

If you prefer not to use a formula, you can use Find and Replace to remove the negative sign directly. Press Ctrl+H (or Cmd+H on Mac) to open the Find and Replace dialog.

In the Find what field, type a hyphen: -. Leave the Replace with field empty. Click Replace All. Excel removes every hyphen from your selected range, turning -50 into 50, -100 into 100, and so on.

This method is faster if you have a small dataset and do not need to preserve the original negative values. However, it is less flexible than ABS because it straightforward deletes the minus sign without any calculation—it works fine for numbers but can cause problems if your data contains text with hyphens.

When to use ABS versus Find and Replace

Use the ABS function when you want a formula-based solution that you can copy, adjust, or undo easily. It is also the better choice if you might need to reference the original negative numbers later, since ABS lets you keep both versions side by side. ABS is the standard approach in professional spreadsheets because it is reversible and clear about what happened.

Use Find and Replace when you have a small number of negative values and you are certain you will never need the negative versions again. It is faster to execute but harder to undo if you change your mind—so only use it if you are confident in the change.

For very large datasets (thousands of rows), ABS is still faster because you write the formula once and copy it down, whereas Find and Replace requires you to manually select each range and run the dialog each time.

Handling mixed positive and negative numbers

If your column contains both positive and negative numbers and you only want to flip the negative ones, the ABS function will convert everything to positive—which may not be what you want. In that case, use a conditional formula instead.

Click on an empty cell and type =IF(A1<0,-A1,A1). This formula checks whether the value in A1 is less than zero (negative). If it is, it multiplies it by -1 to flip the sign. If it is already positive, it leaves it alone. Copy this formula down just as you would with ABS, then use Paste Special > Values to replace the originals.

This approach preserves positive numbers while converting only the negative ones, which is useful when you have a dataset with mixed signs and need to standardize only the negatives.

Common mistakes to avoid

Forgetting to copy the formula down: If you type =ABS(A1) in B1 but do not drag the fill handle down, you will only convert the first number. Always extend the formula to cover your entire range.

Deleting the original column too soon: If you delete column A before pasting the values into it, you will lose your data. Always paste the positive results back into the original column first, then delete the helper column.

Using Find and Replace on the wrong range: If you do not select your data before opening Find and Replace, Excel will search the entire sheet and may remove hyphens from text or dates you did not intend to change. Always select your data range first.

Confusing ABS with other functions: The ABS function only removes the negative sign; it does not round, truncate, or change decimal places. If you need to round your results, use =ROUND(ABS(A1),2) instead, where 2 is the number of decimal places you want.

Frequently Asked Questions

Can I use ABS on a range instead of copying the formula down?

No, you must enter the formula in a cell and then copy it down to each row. However, you can select the range B1:B10 and type =ABS(A1:A10) as an array formula in some versions of Excel, but copying the formula down is more reliable and works in all versions.

What if I want to keep both the negative and positive versions?

Use the ABS function in a helper column (like column B) and do not delete it. You will have the original negatives in column A and the positive equivalents in column B. You can then hide column A if you do not need to see it.

Does ABS work on cells that contain text mixed with numbers?

No. If a cell contains text like "negative: -50", ABS will return an error. You must have pure numbers in the cells for ABS to work. If your data is mixed, you may need to clean it first by removing the text portion.

Can I undo a Find and Replace that removed all the hyphens?

Yes, press Ctrl+Z when ready after the replacement to undo it. However, if you have saved the file, undo may not work. This is why ABS is safer—you can always delete the helper column and start over if something goes wrong.

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

Both produce the same result for negative numbers. ABS(-50) and -50*-1 both equal 50. However, ABS is clearer to read and is the standard Excel function for this task. Use ABS unless you have a specific reason to multiply.