Change How Negative Numbers Are. Adding negative numbers to negative numbers treat the problem like subtraction counting backwards. To change negative numbers to positive and leave positive numbers along ie.
On the right choose an option from the Negative Numbers list and then hit OK. However if you are multiplying a positive integer and a negative one the result will always be a negative number. How to change negative numbers to positive in Excel.
If youre using a Mac press 1.
Right click the selected cells and select Format Cells in the right-clicking menu. Adding negative numbers to negative numbers treat the problem like subtraction counting backwards. All you have to do just multiply a negative value with -1 and it will return the positive number instead of negative. As an Excel professional also you can run the.