Put -1 in a space cell
Copy
Select your column of numbers
Edit/ Paste Special/ Multiply (or Divide)
Now you can delete the -1 from the spare cell.
--
David Biddulph


"Bear" wrote in message
...
Without manually changing each entry how do I change a column of positive
numbers to negative numbers.

Thanks in advance
Bear