Excel: Formulas -> Formula Auditing -> Show Formulas

Toggle the display of formulas in a worksheet.

With VBA, this display can be toggled using the .displayFormulas property of the worksheetView object.