View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Please don't attach files - this is not a binary newsgroup.

XL cells can contain 32767 characters, only the first 1024 will normally
be displayed. You can manually work around this by putting in a line
feed (alt-Enter) at least once every 1024 characters.


In article ,
Patrick wrote:

I am having a problem getting Excel to display all text in a cell. I
am using Excel 97 and need the functionality to record large amounts
of text, as well as the calculation capabilities.

I know that Excel 97 will accept 32,000 characters in a cell and I am
not using anywhere near this. When I enter my text, it is no longer
displayed in the cell. It is there when I click on it but not when the
cursor is in another cell.

I attach a small file to explain what I mean.