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!