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)

On 15 Nov 2005 10:59:31 -0800, wrote:

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

Ron Rosenfeld wrote:
On 15 Nov 2005 10:59:31 -0800, wrote:

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

ofcourse - that is SO OBVIOUS!

thank you so much

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.