How To Do Just About Everything
You have inserted formulas into your Microsoft Excel worksheet, have the results displaying, and now, you want the formulas gone, leaving only the results. This tip works best for situations when you will no longer be editing the numbers calculated by the formula because once you convert a formula to a value, it ceases to calculate.
Formula Showing
In the example at the left (click image to enlarge it) the contents of cell A3 shows a formula to add the cells above it. Our objective is to keep the total number, but get rid of the formula.
Copy Formula Cell
Click in the cell that has the formula, right click the mouse, and then click Copy.
Paste Special
Hover your mouse over the same formula cell, which should now show a blinking, dotted line surrounding it to indicate that the cell is active and copied, again right click your mouse, but this time, click on Paste Special.
Values
On the Paste Special dialog box, click on the left side option for Values. Make no other changes. Click OK
Value Showing
You can press the escape key to exit the copy/paste mode. Now, you will see only a value (number) in the cell where the formula was.
Authority 
