Convert a column of numbers from positive to negative in Excel
Hi, JRoseen,
=a2*-1
copy it down
or insert -1 in the new column copy the original and paste special values
multiply
hth
regards from Brazil
Marcelo
"JRoseen" escreveu:
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?
|