You can enter 32767 characters in a cell but the cell will display only 1024
of these.

The formula bar will display all.

To have more display in the cell use Alt + Enter every 100 characters to
introduce an in-cell linefeed.


Gord Dibben MS Excel MVP


On Mon, 29 Sep 2008 13:37:02 -0700, tarat76
wrote:

I have one spreadsheet that will not allow me to see all the text. I need to
change the format, so that as I type it is still visible. Currently I have
an alotted number of characters and when I pass that amount the certain
number of characters are the only ones I see in the cell, but in the formula
bar I see the full amount. Anyone help?