put -1 in an empty cell, copy it, select the range of cells to be
modified, select Paste Special and pick Multiply.

MaryKaye wrote:

I want to effect a mass change to the sign of numeric values in a range of
cells (rows and columns).