One way:

Put -1 in an empty cell. Copy the cell. Select your column of numbers.
Choose Edit/Paste Special, selecting the Values and Multiply radio
buttons.

In article ,
"Glenda" wrote:

Is there a way through formatting of cells to change
columns of positive numbers to negative or columns of
negative numbers to positive??