View Single Post
  #2   Report Post  
B. R.Ramachandran
 
Posts: n/a
Default

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