Thank you. Unfortunately, we do not want to spend the time to limp around
the problem. Do you know of another sorting spreadsheet type program that
would allow for notes exceeding 1000 characters?

"Dave Peterson" wrote:

Try formatting the cell as General.

Then add alt-enters (to force new lines within the cell) every 80-100
characters.

You'll see way more than what's documented in help.

cp wrote:

Regarding a worksheet with columns A-E; Columns A-D are for name, company,
status, phone #; column E is for notes, some of which are lengthy. I
understand that the autofit height, wrap text formatted cells allow for 32767
characters, and display only 1000. My problem is that all of a sudden in one
of the E column cells, I entered notes, which all showed up as I was typing;
but, when I progressed to the next row, first cell, the cell I just left
appeared as "###############etc." What is with this?
Also is there a way to format the notes column to extend beyond the
32767/1000 character restriction --- or --- should I be using another
softwear program? Thanks, cp

--

Dave Peterson