There is a limit on how much is displayed and a limit on how much can be
copied. For Excel 2003, the display limit is 1024 characters.
Cell can hold 32,767 characters.
Formula bar will display up to 32,767 characters.

Quantro Pro? is Excel's rival. It might be more flexible.

"s.gun" wrote:

im tryin to format a cell so that it automatically gets bigger if i type a
large amount of text.
can ne1 help?? thanx a lot