Turn a Formula into a Static NumberPosted: May 16, 2010
When you create a formula in Excel, the cell shows the result, but consists of the formula.
So for example, you create a formula that adds 2 and 3. The destination cell shows ‘5’, but when you click on that cell it will show you the cell addresses of two cells containing the 2 and the 3.
Sometimes you may prefer to have Excel do the math for you, but have the result as a static number, in this example just a plain old ‘5’ and no cell references.
- Create the formula.
- Edit the cell containing the resulting formula – this means double clicking on it or pressing the F2 key.
- Once your cursor is in that formula cell simply press the F9 key.
- Voila, the only thing showing in that cell is the answer or value created by the formula, the formula no longer exists.