View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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?