If you want to change the sign of the value, you can use a helper cell (or a
column of these helper cells) with formulas like:

=-a2


If you don't want to use a helper column, you can put -1 in an empty cell
Copy that cell
Select the range to fix
Edit|paste special|check multiply and values
clean up that helper cells with the -1 in it.

cindy wrote:

--

Dave Peterson