In xl97+, each cell can contain almost 32k characters. xl95 was the last
version that supported only 255 characters per cell.

But excel does have a problem with cells formatted as text when the length of
the string in the cell is between 255 and 1024. Excel will show ###'s.
Formatting that cell as General will fix the problem.



Manoj wrote:

the # appears as the length of the text data you have entered has exceeded
255 characters. thats the maximum length it will take. try breaking it into
multiple cells.

Hope this solves your problem.

"Rena" wrote:

I am having problems with cells spanned several columns. I selected several
cells (A8 to J8) and merged them as one cell. I checked off 'word wrap' as
well but after I typed in a paragraph (all text), #'s appears in the cell. I
when I tried to print it, it prints the #'s instead of the text that I typed.

Could anyone shed some light? Any information is appreciated.

Thank you in advance.

--

Dave Peterson