Exceljet

Quick, clean, and to the point

Change negative numbers to positive

Excel formula: Change negative numbers to positive
Generic formula 
=ABS(number)
Summary 

To change negative numbers to positive and leave positive numbers along (i.e. get absolute values) use the built-in ABS function. In the example shown the formula in C6 is:

=ABS(B6)
Explanation 

The ABS function is fully automatic. All you need to do is supply a number and ABS will return the absolute value.

Convert negative numbers in place

If you only need to convert negative numbers once, you can convert in-place with Paste Special:

  1. Add -1 to a cell and copy to the clipboard
  2. Select the negative numbers you want to convert
  3. Use Paste Special > Values + Multiply

The video on this page shows this technique and many other paste special shortcuts.

Author 
Dave Bruns
Related formulas 
Excel formula: Count cells that contain negative numbers
Count cells that contain negative numbers
In this example, the goal is to count the number of cells in a range that contain negative numbers. For convenience, the range B5:B15 is named data . This problem can be solved with the COUNTIF function or the SUMPRODUCT function. Both methods are...
Excel formula: Convert negative numbers to zero
Convert negative numbers to zero
In this example, the goal is to convert negative numbers in column B to zero and leave positive numbers unchanged. Essentially, we want to force negative numbers to zero. With the MAX function The MAX function provides an elegant solution: = MAX (...
Related functions 
Excel ABS function
Excel ABS Function

The Excel ABS function returns the absolute value of a number. ABS converts negative numbers to positive numbers, and positive numbers are unaffected.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formulas | 101 Functions

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.