If you enter text longer than 255 characters in a Text formatted cell you
get ######. All versions of Excel and it doesn't matter if the cell is
merged. Best to go with General format or at least not Text if possible.

--
Jim
"jgcrews" wrote in message
...
|I have several text cells merged into a larger single cell. I have word
wrap
| & merge cells checked under formatting. One some of the cells, the text
| entered displays as I expect it to. However, on other merged cells, the
text
| doesn't display - just a series of pound signs. Anyone have a suggestion
as
| to what is causing this and how I go about resolving it?