Convert to an Absolute Number with ABS Function

Tutorial In Brief

Turning a negative number into a positive is quite easy with ABS. This function is specifically for this task.

Quick Intro: It can convert any number into an absolute number. In simple words, it will return a number after removing its sign.

Syntax: =ABS(number)

You just have to refer a negative number into the function and it will turn it into a positive value.

1. In the below example, you have negative values from range A2:A11.
2. Enter =ABS(A2) into B2 and drag it up to the last cell.

Note: This function works even when you have mixed numbers (both positive and negative).

Other Methods to convert Negative Number into Positive

Choose the tutorial that fits best for your case –

1. Multiply with Minus One to Convert a Positive Number in Excel
2. How to convert to an Absolute Number with ABS Function in Excel ?
3. Multiple Using Paste Special to convert Negative Figure into Positive In Excel
4. How to Remove Negative Sign with Flash Fill in Excel ?
5. How to apply Custom Formatting to Show as Positive Numbers in Excel ?
6. How to run a VBA Code to Convert to Positive Numbers in Excel ?
7. How to Use Power Query to Convert Get Positive Numbers ?