It sounds like you want the absolute value. The worksheet function is =ABS(A1) where cell A1 has either a positive or negative value.