mordy,
Put -1 in a cell, select it, Copy. Now select the cells to be changed.
Edit - Paste Special, Multiply. Now you can delete the original cell.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"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?
|