How to Change Negative Numbers to Positive in Excel
Negative numbers serve a purpose in Excel — they represent losses, debits, temperature drops, or any value below zero. But there are plenty of situations where you need to convert them to positive: cleaning up imported data, preparing a report, running absolute-value calculations, or feeding numbers into a formula that breaks on negatives. Excel gives you several ways to do this, and the right approach depends on what you're working with and what you need the result to look like.
What "Converting to Positive" Actually Means in Excel
Before picking a method, it's worth distinguishing between two goals:
- Displaying a negative number as positive (the underlying value stays negative)
- Converting the value itself to a positive number (the cell data changes)
These are not the same thing. A custom number format can make -500 look like 500 on screen, but if you reference that cell in a formula, Excel still reads it as -500. Truly changing the value requires a formula or a Paste Special operation.
Method 1: The ABS Function (Most Common)
The ABS function returns the absolute value of a number — meaning it strips the negative sign regardless of how large or small the number is.
Syntax:
=ABS(number) Example:
=ABS(-150) → 150 =ABS(A2) → returns the positive version of whatever is in A2 This is the cleanest approach when you want to reference or calculate with positive values without overwriting your original data. Use a helper column alongside your original data, apply =ABS(A2) and drag it down, and you have a positive version of every value.
When ABS is the right tool:
- You want to keep the original data intact
- You're feeding values into another formula
- You're working with a mix of positive and negative numbers and want all of them treated as positive
Method 2: Multiply by -1 with Paste Special ✏️
If you need to permanently convert negative numbers in place — without adding a new column — the Paste Special multiply trick is fast and doesn't require formulas.
Steps:
- Type
-1in any empty cell - Copy that cell (Ctrl+C)
- Select the range of negative numbers you want to convert
- Open Paste Special (Ctrl+Alt+V or right-click → Paste Special)
- Choose Multiply under the Operation section
- Click OK
Every negative number in your selected range multiplies by -1 and becomes positive. The values change in place. Delete the helper cell with -1 when done.
Important caveat: This flips all numbers in the selection — positives become negative too. Make sure you're selecting only the negative values, or use a filtered selection first.
Method 3: IF Formula for Conditional Conversion
Sometimes you only want to convert negatives while leaving positive numbers untouched — and you want explicit control over the logic. An IF formula handles this directly.
=IF(A2<0, A2*-1, A2) This reads: "If A2 is negative, multiply it by -1; otherwise, return A2 as-is." The result is always non-negative.
This approach is functionally equivalent to ABS for most use cases, but it's useful when you want to build additional conditions into the same formula — for example, flagging zeros separately or handling blank cells differently.
Method 4: Custom Number Formatting (Display Only)
If the goal is purely visual — you want negative numbers to appear without the minus sign in a printed report or dashboard — custom formatting achieves this without touching the actual data.
Steps:
- Select the cells
- Press Ctrl+1 to open Format Cells
- Go to the Number tab → Custom
- Enter a format like:
0;0or#,##0;#,##0
The second segment in a custom format code controls how negative numbers display. Setting it to 0 (without a minus sign) removes the visual indicator.
This does not change the value. Formulas referencing these cells still treat them as negative. Use this method only when presentation is the concern, not calculation accuracy.
Comparing the Methods
| Method | Changes Actual Value | Requires Helper Column | Works In-Place | Best For |
|---|---|---|---|---|
| ABS Function | No (formula result) | Yes | No | Calculations, referencing |
| Paste Special × -1 | Yes | No | Yes | Bulk in-place conversion |
| IF Formula | No (formula result) | Yes | No | Conditional logic |
| Custom Formatting | No | No | Yes | Display/reporting only |
Variables That Affect Which Method You Should Use 🔍
Data structure matters. If your negatives are mixed in with positives and you can't easily isolate them, the Paste Special method carries risk. The ABS or IF approach in a separate column is safer.
Formula dependencies matter. If other cells are already referencing your negative values, changing them in place (via Paste Special) will silently alter those dependent formulas' outputs. A helper column preserves the original reference chain.
Version and platform matter less here. ABS, IF, and Paste Special have been in Excel for decades and work consistently across Excel for Windows, Excel for Mac, and Excel Online — though the keyboard shortcuts for Paste Special differ slightly by platform.
Data source matters. Numbers imported from external systems (accounting software, CSVs, databases) sometimes store negatives in unusual formats — parentheses like (150) instead of -150. Excel may read these as text rather than numbers, which means ABS won't work until the text is converted to a true numeric value first.
Scale matters. For a dozen cells, any method works fine. For thousands of rows with mixed signs and downstream formulas, a carefully placed ABS column is usually the least disruptive path.
The method that's genuinely right comes down to whether you need the original data preserved, whether other formulas depend on those cells, and whether the end goal is a clean value or just a clean-looking report.