When using auto sum change negative numbers to positive

Copper Contributor



I'm using =a1-a2 in excel to find difference between product expected and product arrived, but when I get more product arriving than what I expected the formula gives me a negative total.


How can I change that negative total to a positive and show a plus sign in front of the number.



Arrived 17
5 Replies






and apply the custom number format +0;-0;0 to the cell with the formula

An alternative would be =ABS(A1-A2) which gives the absolute difference as a positive number.
Thank you - this worked well too!


this worked well too!


One of the neat things about Excel: there are always multiple ways to get from A to B.