How to Convert a Formula to a Value

How to Convert a Formula to a Value. 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.