Hi,

you may experience this behaviour also if cell was previously formatted
as text. It will also show formula instead of result (the formula is
treated as text). - probably your case.

Regards,
Ivan