The following limitations apply to worksheet entries:

32,767 characters per cell
Only 1,024 display in a cell
All 32,767 display in the formula bar.

You can squeeze some additional display characters beyond the 1,024 by
manually inserting line breaks by pressing <Alt + Enter at each point in
the text where you want to insert a new line.
--
Kevin Backmann


"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?