J
James8309
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!
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!