Hi Everyone,

I am having a bit of problem wit subtraction.

if Cell A1 = 100 and Cell B1 = 500, C1 = A1 - B1 will return - 400. I
don't want to see any negative sign infront of the result.

I have list of numbers in Columns A1:A50, Columns B1:B50 and C1:C50
will have my result of A - B. Not all cells in Column A have greater
value than Column B.

1. I just want the difference in positive numbers. How do I do that?

2. if my cell has numbers in custom format of [mm]. How do I change
them into normal numbers without them being changed to some weird date
figures?

Thank you for your help in advance!

In C1 enter:
=ABS(A1-B1)
--
Gary''s Student - gsnu2007j

1. =ABS(A1-B1)
2. If you want the number of minutes, use =A1*24*60 and format as General or
Number, not as date or time.
--
David Biddulph

"James8309" wrote in message
...
Hi Everyone,

I am having a bit of problem wit subtraction.

if Cell A1 = 100 and Cell B1 = 500, C1 = A1 - B1 will return - 400. I
don't want to see any negative sign infront of the result.

I have list of numbers in Columns A1:A50, Columns B1:B50 and C1:C50
will have my result of A - B. Not all cells in Column A have greater
value than Column B.

1. I just want the difference in positive numbers. How do I do that?

2. if my cell has numbers in custom format of [mm]. How do I change
them into normal numbers without them being changed to some weird date
figures?

Thank you for your help in advance!