I have a column of 500 numbers which are all positive. I would like to change
them to negative. Appreciate any help. Thanks.
Ken
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks