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.