Change the format to General (from Text).

eve wrote:

When typing in a text cell, and entry becomes lengthy, I see #### filling the
cell rather than the text. The text is still there when you edit the cell.
It is similar to when you type in a numeric field and the number is too long
to display. I already turn on word wrap and auto adjust the row height.

--

Dave Peterson