Explanation
The ABS function is fully automatic.
ABS converts negative numbers to positive numbers, and positive numbers are unaffected.
Change negative numbers to positive
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)
