Can I increase 1024 max in a cell

G

Gerry

I have Excel 2002 running on Windows XP professional.

Is there any way to increase the number of characters
that can be displayed in a cell. When I merge cells and
wrap text, after it gets to the 1024 character max the
text is no longer visible.

Thanks

Gerry
 
H

Harlan Grove

Thats the max number that can be visible,you can put something like
32767 in one but you aren't going to see them.

That's what the specs say, but it's not correct. With regularly spaced newline
characters (ASCII LF, 10 decimal), word-wrap enabled, small typesize, and extra
wide and tall cells, Excel will happily display 10,000 or more characters.

The OP may be able to insert newlines in order to display more than 1024
characters.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top