Negative to positive

[ExcelNovice]

Is there an easy way for me to change the negative numbers in a cell to positive numbers?

 

[PaddyD]

put -1 in a spare cell, select it & copy it. select the range of numbers you want to change, go to edit | paste special...select multiply & hit OK

paddy

 

[plettieri]

Hi:

There is a nice features on ASAP-Utilities that does that and a lot more...free down load ASAP-Utilities.com

hope this helps
pll