Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Aug 2008
    Location
    Jerusalem, Israel
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    changing a formula to a number (Vista/Office2007)

    How do I change a cell that has a formula in it to be just a number, not dependent on any formula? When I get a value for one month and then want to get the corresponding value for the next month, I want the previous month's value to stay the same and not change when I change some of the values in the formula the next month. Do you know what I mean? 20 years ago I used to use the spreadsheet "1-2-3" wherein one of the function keys would change the formula into a number value but I can't seem to find any function or function key in Excel that will do the same thing. Thanks for your help.

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

    Re: changing a formula to a number (Vista/Office2007)

    Select the cell or cells.
    Click the Copy button on the ribbon.
    Click the little arrow on the right hand side of the Paste button.
    Select Paste Special from the dropdown menu.
    In the Paste Special dialog, select Values, then click OK.

  3. #3
    Star Lounger
    Join Date
    Aug 2008
    Location
    Jerusalem, Israel
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing a formula to a number (Vista/Office2007)

    Thanks for your clear instructions. That does it. I did some experimenting and it seems that copying, clicking the paste arrow and then just clicking on "Paste Value" does the same thing. Am I correct, or is there some advantage to going first to Paste Special and then Values?

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

    Re: changing a formula to a number (Vista/Office2007)

    Using Paste Values is easier, and going through the Paste Special dialog isn't necessary unless you need the extra options the dialog offers.

    I just described the more generic option because I don't have Excel 2007 myself (I still use Excel 2002 / 2003).

  5. #5
    Star Lounger
    Join Date
    Aug 2008
    Location
    Jerusalem, Israel
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing a formula to a number (Vista/Office2007)

    Thanks.

Posting Permissions

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