Changing Values from Negative to Positive and Visa Versa

February 13, 2020

To mass change negative values to positive or visa versa, simply use the Multiply Paste Special Feature. The trick is that you have to create a temporary value of -1 in a separate cell first and then Copy and Paste Special this value over the data, using the Multiply option.

 

Share on Facebook
Share on Twitter