ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I fix getting #### rather than text in a text cell? (https://www.excelbanter.com/excel-discussion-misc-queries/71154-how-do-i-fix-getting-rather-than-text-text-cell.html)

eve

How do I fix getting #### rather than text in a text cell?
 
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

How do I fix getting #### rather than text in a text cell?
 
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


All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com