Easy way to make negative data positive?

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

Guest

I have a large section of negative data that I want to convert to positive
i.e. - 2 becomes 2 etc. Is there a quick way to do this? Thanks!
 
Sarah -

Select a blank cell somewhere and enter -1.

Edit | Copy.

Select the range of cells containing numbers to be converted.

Edit | Paste Special | Multiply.

- Mike
www.mikemiddleton.com
 
Back
Top