In another cell put -1
Copy that cell
Select all cells to convert
EditPasteSpecial and select the Multiply option.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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?