Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Covert postive values to negative (2000., 2002, 20

    Does anyone know how to convert postive number to negative i.e. select the numbers that you want to convert to negative and do the conversion in one go. these number swill be used in calculations i.e. -1+1 =0.

    Thanks,

    skender

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Covert postive values to negative (2000., 2002, 2003)

    Enter -1 in an empty cell.
    Copy the cell to the clipboard (Ctrl+C or Edit | Copy or click the Copy button on the toolbar)
    Select the cells you want to convert.
    Select Edit | Paste Special...
    Click the Multiply option, then click OK.
    You can clear the cell with -1 now.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Covert postive values to negative (2000., 2002

    thanks a lot Hans

Posting Permissions

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