Is there maximum number of characters per cell?
I wrote:
Dave Peterson wrote:
You can actually see more that 1024 characters by adding alt-enters every 80-100
characters.
I tried that and I still get ############################ as soon as I
exceed the 1,024 characters/cell display limit. What could I have done
wrong? Are there any special options to be set for this to work?
BTW, I use Excel 2002 (XP).
Problem is solved now. What I did wrong was that I still had formatted
the cell as "Text" (under "Category"). When I changed that cell format
to "General", your method worked. So, thanks for the tip.
Peter
|