cell reference show cell name (ie. D45) and not cell value
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.
|