+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    JKB
    Guest

    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

  2. #2
    B. R.Ramachandran
    Guest

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

    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


  3. #3
    JKB
    Guest

    RE: How do I change a column of 500 numbers from positive to negat

    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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1