Change Negative Numbers to Positive in Excel

When you need to change the negative numbers to positive or vice versa numbers.

This Quick tricks you can easily change all the negative numbers to positive numbers.

Step 1:

Type any were -1 and copy the cell


Select all the cell you want to change the negative numbers convert to positive numbers, for multiple selection hold the Ctrl key + click the all negative cells.

Right click the mouse and select past special and again click the past special


Past special dialog box select the check on All and the operation section select the Multiply and click OK.

All the selected number will be changed into the positive number

In the mathematical terminology: when we multiply any negative number to negative figure will be change into positive for example: (-) x (-) = (+):

No comments:

Post a Comment

Recommended for You


Related Posts Plugin for WordPress, Blogger...