The fastest way to flip negative numbers to positive
To change a negative number to positive in Excel, use the ABS function, which stands for absolute value. Type =ABS(cell) where "cell" is the location of your negative number — for example, =ABS(A1) — and press Enter. The result appears in your new cell as a positive number.
If you have a column of negative numbers you want to convert all at once, enter the formula in the first empty cell next to your data, then copy it down to match the number of rows you have. This takes about 30 seconds and works whether your numbers are in a single cell, a row, or an entire column.
Key Takeaways
- The ABS function converts any negative number to its positive equivalent in a single step.
- You can use ABS on a single cell or copy the formula down an entire column to convert multiple numbers at once.
- The original negative numbers stay unchanged unless you copy the results and paste them back as values.
- If you need to flip the sign of numbers that are already positive, use a minus sign in front of the cell reference instead.
Using ABS for a single negative number
Click on an empty cell where you want the positive result to appear. Type =ABS(A1), replacing A1 with the cell that contains your negative number. Press Enter. The cell now shows the positive version of that number.
The original number in A1 does not change — the ABS formula creates the positive version in your new cell. If you want to replace the original negative numbers with positive ones, you will need to copy the results and paste them back as values, which is covered in the section below.
Converting an entire column of negative numbers
Click on the first empty cell in the column next to your negative numbers. Type =ABS(A1) if your negatives are in column A, or adjust the letter to match your actual column. Press Enter.
Now click on that cell again to select it. Look for the small square in the bottom right corner of the cell — this is the fill handle. Click and drag it down to the last row that contains a negative number. Excel copies the formula down automatically, and every negative number in that range becomes positive in your new column.
Replacing the original numbers with the positive versions
After you have used ABS to create positive numbers in a new column, you may want to delete the original negative column and keep only the positive results. First, select all the cells in your new column that contain the positive numbers from the ABS formula.
Right-click and choose Copy. Then click on the first cell of your original negative column. Right-click and select Paste Special. A dialog box opens — click on Values and then OK. This pastes only the numbers, not the formula, so your original column now contains positive numbers instead of negative ones. You can now delete the helper column with the formulas.
Flipping the sign of positive numbers to negative
If you need to do the opposite — turn positive numbers into negative ones — use a different approach. Click on an empty cell and type =-A1, replacing A1 with the cell containing your positive number. Press Enter. The result is negative.
You can copy this formula down a column the same way you would with ABS. The minus sign in front of the cell reference multiplies the number by negative one, which flips its sign. This works on any number, whether it starts positive or negative.
When ABS does not work the way you expect
The most common mistake is forgetting that ABS creates results in a new location — it does not change the original cells. If you type the formula in the same cell as your negative number, you will get a circular reference error. Always put the ABS formula in a different cell than the one you are referencing.
Another issue happens when negative numbers are stored as text rather than actual numbers. If =ABS(A1) returns an error or does not work, your data may be text. You can check by clicking on the cell — if the number is left-aligned instead of right-aligned, it is text. To fix this, you may need to use the VALUE function: =ABS(VALUE(A1)). This converts the text to a number first, then applies ABS.
Using Find and Replace for a quicker method
If you have a large dataset and want to convert all negatives to positives without creating a helper column, you can use Find and Replace. Press Ctrl+H (or Cmd+H on Mac) to open the Find and Replace dialog.
In the "Find what" field, type ^- (a caret followed by a minus sign). Leave the "Replace with" field empty. Click Replace All. This removes all the minus signs from your numbers in one action. This method is faster for large columns but less flexible if you need to keep the original data intact — use ABS if you want to preserve the negatives and create a separate positive column.
Frequently Asked Questions
Can I use ABS on a range of cells at once instead of copying the formula down?
No, you need to enter the formula in at least one cell and then copy it down to the other rows. However, you can select multiple cells and type the formula once, then press Ctrl+D to fill down, which is slightly faster than dragging the fill handle.
What if some of my numbers are already positive and some are negative?
ABS converts all of them to positive, regardless of their starting sign. If you only want to convert the negative ones and leave positives alone, you will need a more complex formula like =IF(A1<0,-A1,A1), which checks if the number is negative first.
Does ABS work on numbers with currency symbols or percentages?
ABS works on the numeric value, so $-50 becomes $50 and -25% becomes 25%. The formatting stays the same — only the sign changes. If the formatting does not carry over, you can copy the format from the original cell and paste it onto the new results.
Can I undo the Find and Replace method if I make a mistake?
Yes, press Ctrl+Z immediately after Replace All to undo the change. However, if you close the file without undoing, the change is permanent. For this reason, ABS is safer because it keeps your original data in a separate column until you are sure the conversion is correct.