Why is my text cell showing as # symbols when entered

[Podpopper]

It is not because the cell is too small. I have wrapped the text and it shows
the text when I double click on cell, but when I click to another cell it
only shows # symbols. It seems like the cell is merged incorrectly, but I
have unmerged cells and redone the merge and nothing has changed.

 

[RagDyer]

You're probably experiencing the "text bug"!

Format the cell(s) to "General".


There seems to be a quirk (bug), where in a Text formatted cell of more then
approximately 256 characters, you'll get the ###'s.


Stranger yet, if you keep typing, the true text *returns* when the character
count exceeds 1024.


General format should work for the "in-between" character count.