| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is my text cell showing as # symbols when entered
It is not because the cell is too small. I have wrapped the text and it shows
the text when I double click on cell, but when I click to another cell it only shows # symbols. It seems like the cell is merged incorrectly, but I have unmerged cells and redone the merge and nothing has changed. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why is my text cell showing as # symbols when entered
You're probably experiencing the "text bug"!
Format the cell(s) to "General". There seems to be a quirk (bug), where in a Text formatted cell of more then approximately 256 characters, you'll get the ###'s. Stranger yet, if you keep typing, the true text *returns* when the character count exceeds 1024. General format should work for the "in-between" character count. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Podpopper" wrote in message ... It is not because the cell is too small. I have wrapped the text and it shows the text when I double click on cell, but when I click to another cell it only shows # symbols. It seems like the cell is merged incorrectly, but I have unmerged cells and redone the merge and nothing has changed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I get # symbols in my cell instead of text | Excel Discussion (Misc queries) | |||
| cell not showing all the text entered? | Excel Discussion (Misc queries) | |||
| The numbers entered change to symbols when leaving the cell | New Users to Excel | |||
| Why does text in a cell appear as a line of '#' symbols? | Excel Discussion (Misc queries) | |||
| showing symbols on a two axis chart | Charts and Charting in Excel | |||
Linear Mode
