+ Reply to Thread
Results 1 to 4 of 4

Save calculated results in cells not thge formulas used to calculate them

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    2

    Save calculated results in cells not thge formulas used to calculate them

    I programmed a number of cells with formulas. The cells now display the calulated results of the formulas, but if I try to cut and paste the cells into a new spreadsheet, or use the cells in a mail-merge with Word, Excel wants the information from the cells that were used to program the cells with the formulas. I want to save the information produced by the formulas not the formulas themselves.

    Thank you. I can't figure out how to do this.

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Save calculated results in cells not thge formulas used to calculate them

    If you select the cells, choose 'Copy', then when you want to put them somewhere, use Paste Special > Values and it will paste the values from the cells, and not the formulas.

    - Moo

  3. #3
    Registered User
    Join Date
    11-28-2012
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Save calculated results in cells not thge formulas used to calculate them

    Hi Moo -

    Wow! Thank you SO MUCH!!! I am an inexperienced Excel user and had no idea how to do this. You rock - thanks again Moo.

  4. #4
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Save calculated results in cells not thge formulas used to calculate them

    You are quite welcome. Glad I could help.
    - Moo

+ 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