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.