Microsoft Office Tutorials and References
In Depth Information
Perform One Time Calculations Using a Formula
Click the Copy button.
Select the cell you want to change the contents with the formula.
Click the Paste button arrow, and then click Paste Special .
Click the Values option.
Click OK .
The original data is replaced with the changed data.
When you’re done with the temporary formulas, select the cells, and delete