Type -1 in a cell, then copy that cell.

Then select the range of numbers to change.

Menu EditPasteSpecial

Click Multiply, then OK

Clear the cell with -1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JRoseen" wrote in message
...
Excel 2003. We would like to copy a column of numbers and then convert the
whole column (each number in the column) from positive to negative. Can
this
be done?