ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I get more than 255 characters to display in a merged cell (https://www.excelbanter.com/setting-up-configuration-excel/190357-how-do-i-get-more-than-255-characters-display-merged-cell.html)

RQS9

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

Dave Peterson

How do I get more than 255 characters to display in a merged cell
 
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.

RQS9 wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com