Once the formula is entered as Text, changing cell number format has no
effect, since XL interprets it as as text string.

Format the cell as General, then reenter the formula.

In article ,
Rich D wrote:

that enables me to see all my formulas or not, but it didn't solve the
problem. There is something messed up in that it won't allow me to change
formats in cells either.