How do I change minus numbers to + numbers in a col in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to highlight a column or a row and change all of the numbers
from negative to positive or vice versa without doing the change cell by
cell? Thanks
 
Paul L said:
Is there a way to highlight a column or a row and change all of the
numbers
from negative to positive or vice versa without doing the change cell by
cell? Thanks
Click to expand...

Put -1 in a spare cell, and Copy. Select the cells you want to change, then
Paste Special/ Multiply
 
Back
Top