I know this has been answered but you can do this in one step by copying the
column and then paste special and select SUBTRACT. The cells you are pasting
to, need to be blank.

"JRoseen" wrote:

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?