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

J

JKB

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

B. R.Ramachandran

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
 
J

JKB

Thank you, your suggestion worked just fine.
Ken

B. R.Ramachandran said:
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
Click to expand...
 
Top