my boss and i have randomly tested this problem.
in one cell you type =A23. of course we are expecting a value but instead it
resulted in A23.

what's interesting is that if you copy a cell that does give you the value,
this cell where you're having problems will be fine and return a value.

please advise how to resolve this problem or if it is a bug and there's just
an available workaround.

thanks.