Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell text based on 4 condition test | Excel Worksheet Functions | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
Moving text from one cell to another. | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |