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

Enter -1 into some cell, and copy it. Select the column or range of cells
to be changed, right-click, and click Paste Special Multiply OK. You can
now delete the -1.