How do you change the sign (e.g. +3 to -3 OR -3 to +3)

[Chris.Holland16]

I need to know how to automatically change the sign of a number (it
could be either positive or negative)

Please could someone tell me how to do this


(this is such a simple thing but I can't figure it out)

 

[Ron Rosenfeld]

I need to know how to automatically change the sign of a number (it
could be either positive or negative)

Please could someone tell me how to do this


(this is such a simple thing but I can't figure it out)

multiply by -1


--ron

 

[Chris.Holland16]

multiply by -1


--ron

ofcourse - that is SO OBVIOUS!

thank you so much

 

[mbarron]

Another method (a non formula method) would be to put "-1" in a cell,
then copy that cell.
Next, highlight the cell(s) whose signs you want to change. Right
click and choose Paste Special... In the middle of the window there is
an "Operation" section. Choose multiply and click okay. All of the
numbers in you range will have had their signs changed.