View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jgcrews jgcrews is offline
external usenet poster
 
Posts: 4
Default Excel 2007: Word wrapping in merged cells

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

"Jim Rech" wrote:

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?