Is there a formula for turning a negative number into the same number,
but positive? i.e. -20 into 20, or -34627 into 34627.

Thanks
TC

=ABS(##)

where ## is the number or cell reference


--
MartynGriffin
------------------------------------------------------------------------
MartynGriffin's Profile: http://www.excelforum.com/member.php...o&userid=30496
View this thread: http://www.excelforum.com/showthread...hreadid=501504

You can use ABS( ), which takes the absolute value (or magnitude). You
can also multiply by -1, but if the other number is positive this would
become negative.

Hope this helps,

Pete

1. Put -1 in an un-used cell
2. Copy the cell
3. Select the cells you want to change and
4. Paste/Special and check the multiply button
--
Gary''s Student


" wrote:

Is there a formula for turning a negative number into the same number,
but positive? i.e. -20 into 20, or -34627 into 34627.

Thanks
TC

If your value is in A1, then type =sum(A1-A1-A1)
And you will get the negative of the positive and vice versa.

"Pete" wrote:

You can use ABS( ), which takes the absolute value (or magnitude). You
can also multiply by -1, but if the other number is positive this would
become negative.

Hope this helps,

Pete