Why is Excel displaying the formula as text
 

Perhaps there is an apostrophe to the left of the = sign.
--
Brevity is the soul of wit.


"Richard" wrote:

This isnt the situation where the formula versus value is being shown. This
is a situation where it thinks the formula is a text value.