Occasionally when I type in a formula in Excel, instead of getting the
results, the formula just shows up instead.

As an example, if I type "=$A$2" and hit enter, instead of getting the
contents of what is in cell A2, I just see the formula "=$A$2" instead.

I do not understand what causes this to happen and have not been able to
find anything in the help files.

Thanks,
--
Perry K