Cell displays a string of apostrophes

[Maike13]

I have a sheet that contains a web link in one of the cells. For some reason that cell now displays a string of apostrophes instead of the link text. The link is still there as clicking on the cell takes me to the correct web page. What's going on and how do I get the text to display?

Thanks

Monopods (Odd cell display).xlsx
	A	B	C
1	``````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````
2
3
Sheet1

 

[6StringJazzer]

I have never seen anything like this for a hyperlink. It looks like the kind of thing that happens if you accidentally hold down one key. Do you have a cat?

Right-click on the cell and select Edit Hyperlink near the bottom of the menu. In the pop-up window see what is in "Text to display". Edit to suit.

 

[Maike13]

I have never seen anything like this for a hyperlink. It looks like the kind of thing that happens if you accidentally hold down one key. Do you have a cat?

Right-click on the cell and select Edit Hyperlink near the bottom of the menu. In the pop-up window see what is in "Text to display". Edit to suit.

Thanks. I knew I was missing something simple. That fixed it. No cat but we do have a small dog

 

[6StringJazzer]

Easy to fix, but a total mystery as to how it happened in the first place.

All's well that ends well!