character limit in cell?

[abby]

I merged several cells and entered text. I have it set
to 'wrap text' so it will all fit in the merged cells.
If the text is only 1/2 of the third row it is all
displayed. However, if I enter any more text than that
it displays as '#######'. Is there a limit on the number
of characters I can enter? Can that be changed. There
is still room in the merged cells to hold more text.

 

[Earl Kiosterud]

Abby,

You don't seem to be getting any takers on this one. ####, to my knowledge,
shows up only when you have a number in a cell (not text), and it's too big
to display in its entirety. Excel will lop of text that doesn't fit, but
not digits of a number. I've tried to reproduce your merged cells with Wrap
text problem, and it is behaving as I described above. No amount of messing
with the row height, or Format - Row - Autofit, will reproduce your problem.

 

[Lady Layla]

From HELP within Excel -- Excel limitations - characters in a cell



32,767 characters. Only 1,024 display in a cell; all 32,767
display in the formula bar.

: I merged several cells and entered text. I have it set
: to 'wrap text' so it will all fit in the merged cells.
: If the text is only 1/2 of the third row it is all
: displayed. However, if I enter any more text than that
: it displays as '#######'. Is there a limit on the number
: of characters I can enter? Can that be changed. There
: is still room in the merged cells to hold more text.

 

[Dave Peterson]

Try formatting the cell as General.

If all the text doesn't appear (just truncates at the bottom), you could add
some alt-enters to force a new line within the cell.

And autofitting of merged cells doesn't work, but Jim Rech has posted this
routine that may help you (if you have the problem):

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm