changing a range of positive numbers to negative

[mevans]

What is the easiest way to change a range of positive numbers to negatives? thanks!!

 

[erik.van.geit]

HEllo, mevans,
welcome here!

Type -1 in any cell
copy that cell
select the range you want to change form + to -
rightclick and choose pastevalues: in that box choose "multiply"

kind regards,
Erik

 

[Norie]

Well you could put -1 in a cell.

Then select that and goto Edit>Copy.

Then select the range of positive numbers tou want to change to negative numbers.

Then goto Edit>Paste Special... and then in the Operation section select Multiply.

 

[mevans]

Thanks! That's much quicker than what I was doing!