I have been pulling my hair out over this for a very long time:
On certain cells only:
I click “+” and use the arrows/mouse to select a cell because I want the contents of that cell to appear in this cell.
The cell shows the address of that cell, i.e. it shows “R34” instead of the number “7” which is the content of cell R34
It seems the problem is to do with the referred to cell, i.e. cell R34, because wherever I refer to that cell, it does the same thing, will not allow me to refer to that cell content. Despite the fact that cell R34 appears to be the same as all the other cells. It shows it’s content “7” seemingly correctly.
This seems to happen quite rarely, but when it does, that certain cell (R34 in this case) can never be fixed, no matter what I do.