Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multipication of cells by same number (2000)

    What is the easiest and best way to multiply all numbers on the graph by 1.76, seee screen shot.
    All numbers show need to be multipled by 1.76

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

    Re: Multipication of cells by same number (2000)

    Enter 1.76 in an empty cell.
    Copy the cell to the clipboard.
    Select the range with the cells you want to multiply.
    Select Edit | Go To...
    Click Special...
    Select the Constants option.
    Click OK.
    Select Edit | Paste Special...
    Click the Multiply option.
    Click OK.
    You can now clear the cell in which you entered 1.76

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multipication of cells by same number (2000)

    That is very impressive Hans,
    Exactly what l required.

    Many many thanks for that.

Posting Permissions

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