How do I change a column of 500 numbers from positive to negative
 

I have a column of 500 numbers which are all positive. I would like to change
them to negative. Appreciate any help. Thanks.
Ken

Hi,
In some other cell enter -1. Select and copy that cell, then select the
column of numbers, right click and select 'Paste Special' (you can also
access Paste Special under 'Edit' in the Toolbar), select 'Multiply' and
click 'OK'. Now you can get rid of the -1 in the helper cell you created.
Regards,
B. R. Ramachandran

I have a column of 500 numbers which are all positive. I would like to change
them to negative. Appreciate any help. Thanks.
Ken

Thank you, your suggestion worked just fine.
Ken

"B. R.Ramachandran" wrote:

Hi,
In some other cell enter -1. Select and copy that cell, then select the
column of numbers, right click and select 'Paste Special' (you can also
access Paste Special under 'Edit' in the Toolbar), select 'Multiply' and
click 'OK'. Now you can get rid of the -1 in the helper cell you created.
Regards,
B. R. Ramachandran

I have a column of 500 numbers which are all positive. I would like to change
them to negative. Appreciate any help. Thanks.
Ken