Excel 2007: Word wrapping in merged cells

[jgcrews]

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?

 

[Jim Rech]

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
|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?

 

[jgcrews]

Thanks Jim for the quick response. I changed the format to "General" and it
solved the problem. The Excel documentation stated that the maximum number
of characters per cell is 32,767 so I thought that would apply. Since it was
purely text being entered (notes from telephone calls), I assumed that "Text"
was the proper format to use. I learn something new (& screwy) every day.

Jeff