If that doesn't work, go to Tools;Options and uncheck the Formulas box on the
View tab, Window options.

"kanye" wrote:

The Calculation in Tools is set to automatic & the result of the formula is
shown during Function; however, the result of the formula will not show on
the worksheet, just the formula itself.