Discussion Locked

Change the sign of a number in Excel

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How can I change the sign(-/+)of a range of numbers in Excel?

1 reply

by marcelo

I understand:
you want to change the sign(+/-) of a range of cells with numbers in excel(for example $A$1:$A$3).
Then:
In another cell (ex.$B$1), put -1 (minus one).
Select the cell B1, then Edit->Copy.
Select the Range to change ($A$1:$A$3),then Edit->Paste Special -> Paste:Formula AND Operation:Multiply.
And hoop the numbers in the cells are now in the opposed sign.
Good look.

This discussion is closed to new replies.