View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peter Frank
 
Posts: n/a
Default 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