How do I fix getting #### rather than text in a text cell?

[Guest]

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]

Change the format to General (from Text).

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.