how can I globally change minus numbers to positive ones?
 

how can I globally change minus numbers to positive ones?
 

If the numbers are in a contiguous range:
Type -1 in an empty cell; copy it; select the range of negative numbers and
use Edit|Past Special-multiply. Now delete the cell with -1.

If the numbers are in a column mixed in with positive: insert a helper
column; In top cell of helper column enter =ABS(A1) ... change A1 to fit
your situation
Copy this down the column; Now use Copy and Paste Special but this time
specify Values. Now you have a column of positive numbers and can delete the
original column.

Any help?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"james" wrote in message
...