Displaying Formulas

You may want to evaluate the structure of a worksheet to see that the formulas are correct. To see the formulas in your worksheets (such as =B1&” “&C1) rather than the results of the formulas (Mickey Mouse). This helps you find incorrect cell references in displayed formulas that are causing inaccurate results (but not error values) in the worksheet. Displaying all worksheet formulas also enables you to easily print all formulas used in the worksheet for purposes of documentation. This step is a good safeguard in case you accidentally delete or lose the worksheet or if the worksheet becomes damaged.

Try This        

1. From anywhere in the worksheet, choose Tools, Options; then click the View tab.  

2. Select the Formulas check box; then click OK.  

3. To display the results again, choose Tools, Options; then clear the Formulas check box on the View tab.

OR 

1. On the keyboard, press CTRL + ` (grave accent).