TEXT() formula Reverting to Text value

I’m finding that when I use the TEXT function, the formula sometimes reverts to text (so I lose the formula). This is currently happening in a merged cell using the formula =TEXT(date,“mmmm yyyy”)

Could you elaborate more on this?

It is inconsistent. If I see it happen again, I’ll let you know.