MS Excel

D

Dave Peterson

=if(a1>0,-a1,a1)

or ...

=-abs(a1)

==========
If you're careful, you can do this without formulas.
Put -1 in an empty cell
copy that cell
select your cells to change (click on the first and ctrl-click on subsequent)
edit|paste special|check multiply

Clean up that helper cell with -1 in it.
 
Top