Why is an absolute reference formula displayed as text?

Question

excel

Problem with EXCEL 2013.
As soon as I change one relative reference to an absolute one in the formula (D1 -> $D$1), the whole formula becomes text, and the cell format changes from general to text.
The same problem, if I enter into a cell (the "general" format) a simple absolute reference - =$D$1.
The formula does not work and is displayed as text.

Answer 1

Try to change with the F4 key, placing the cursor on the desired link