In a blanks cell enter the value -1
Copy this cell
Select all the 'problem' cells
Use Edit | Paste Special and specify multiply
Now delete the cell with -1

best wishes
Bernard

"bmordy" wrote in message
...
I need to quickly change many cells from a positive number to a negetive
number.
For example 20 to -20.
What is the most efficient way to do this?