Excel offers a nice trick to convert data that is computed into static data. Consider the example below:
In this spreadsheet, each of the three months (Month 1, Month 2, and Month 3) earn interest and the total of all of the months and respective interests are computed in Column G in the Quarter Totals. The plan is to copy the results to the appropriate column in Column I through Column J. When cell G3 is copied, you want the 142.73 to be copied and not the formula that produced the 142.73. Then you could use the same table area in Columns A - G for the next quarter. The question is how to copy the value and not the formula/function that produced the value. And the answer is 'easy.'
Selecting a cell in Column G will display the function that produced the results. You want to copy the results rather than copy the function.
 |
 |
 |
| Select the range of cells to copy with the familar Edit + Copy. Then select the cell where the paste should start. | ||
The difference in the process is what you do right now. You don't select to paste, but use the Paste Special feature instead.
Choose the Edit + Paste Special from the menu.
This will activate the Wizard which lets you paste in many, many different ways.
Simply click beside Values and click on the OK button.
This will paste the values (and not the functions) in the cells being copied to the location selected for the paste.
You may want to apply some cell formatting features to make the new values be displayed the way you wish them viewed.
 |
 |
| The usual Format + Cells.... | Then select the type of formatting you desire. |
And the results should be as you would expect. Note the display of 142.73 is the rounded version of 142.7296 based on the selection of formatting the cell as a number with 2-decimal places displayed. Also note the absence of function in the cell - the value not the function was copied.
