How do I get more than 255 characters to display in a merged cell

R

RQS9

When I put more than 255 characters in a merged cell all get is a line of
####...
How can I dispaly all the characteres?
 
D

Dave Peterson

Try changing the numberformat from Text to General.

If you have lots and lots of text, you may have to add alt-enters every 80-100
characters to see all the text.
 
Top