![]() |
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. |
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