View Single Post
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

Excel will only display so much text in a cell. The exact amount depends on
the column's width but even at the maximum your 2900+ characters will not
all display.

I'd suggest using a text box. See attached.

--
Jim
"Patrick" wrote in message
...
| Hi,
|
| 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.
|
| Thanks in advance,
|
|
| Patrick