Formula in cell instead of result

[PaulS]

I managed to create a number of complex formulas, but I have a problem to get this problem solved.
I have a cell with the most simple equation: =Adreslist!C2
The result is not a name (which is in Adreslist!C2), but I see the formula in the cell.
What is the reason that this does not work?
Also the formula =Adreslist!C2&" "&Adreslist!C4 returns the same formula in the cell.
I am sure there is an expert who knows the reason.
Thanks,
Paul

 

[VoG]

Try formatting the cell as General and re-entering the formula.

 

[PaulS]

I made both sides 'General'. This was the solution, but I don't know why.............
Thank you,
Paul