Joyce

Excel will only display the first 256 characters ina cell, up to 32,000 or
something similar can be displayed in the formula bar. (To check this look
up excel limits in help, sorry I only have a beta on this machine with no
help files)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Joyce" wrote in message
...
How do I show all the text in a cell? I have tried the auto-fit options
for
both row and column and the wrap alignment option and it still not showing
all the text I have typed. It didn't do it in short paragraphs but with
the
longer ones--the last 2-3 sentences are missing.