Try entering -1 in the cell to copy to first. Then copy the cell,
select the cell to copy to and choose edit-paste special with multiply
selected.

Clare wrote:

Does anybody know how you can make a positive number become a negative number
when copied into a different cell in Excel?

Thank you