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

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
Date: Fri, 06 Jun 2008 12:06:22 -0500

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
.

Prev by Date: Can't activate an add-ins
Next by Date: Re: Multiple Excel files visible
Previous by thread: Can't activate an add-ins
Next by thread: Re: Multiple Excel files visible
Index(es):
- Date
- Thread

Relevant Pages

Re: Text in cells is truncated.
... add alt-enters every 80-100 characters. ... Joe wrote: ... Dave Peterson ...
(microsoft.public.excel.misc)
Re: Wrap text problem in Excel 2003
... I don't think that 1024 number will be a problem if you add those alt-enters ... every 80-100 characters. ... I've seen well over 5000 characters with font size small enough, ... >> Dave Peterson ...
(microsoft.public.excel.misc)
Re: Why Excel doenst display all text in a cell
... > How many characters are in that cell: ... > How many alt-enters did you insert? ... I've found every 80-100 characters ... >>> Dave Peterson ...
(microsoft.public.excel.newusers)
Re: Wrap text problem in Excel 2003
... I put alt-enters every 80-100 characters to force new lines in the cell. ... >> Dave Peterson ...
(microsoft.public.excel.misc)
Re: Why Excel doenst display all text in a cell
... > How many characters are in that cell: ... > How many alt-enters did you insert? ... I've found every 80-100 characters ... >>> Dave Peterson ...
(microsoft.public.excel.newusers)