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

With those large "notes", you might consider just a hyperlink in your
database to the notes written elsewhere rather than trying to enter them all
in one cell.

Vaya con Dios,
Chuck, CABGx3



"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

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

This spreadsheet is formatted to present updated information to our clients,
so would the hyperlink work. In other words, the spreadsheet IS our only
place for these notes, so that we do not have to double our work. Do you
know of a better program for us to consider?

"CLR" wrote:

With those large "notes", you might consider just a hyperlink in your
database to the notes written elsewhere rather than trying to enter them all
in one cell.

Vaya con Dios,
Chuck, CABGx3



"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

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

You could put the large notes on "other" sheets in the same Workbook, which
would still be part of the same file to be transported as
usual...............then hyperlink to them........

Vaya con Dios,
Chuck, CABGx3



"cp" wrote:

This spreadsheet is formatted to present updated information to our clients,
so would the hyperlink work. In other words, the spreadsheet IS our only
place for these notes, so that we do not have to double our work. Do you
know of a better program for us to consider?

"CLR" wrote:

With those large "notes", you might consider just a hyperlink in your
database to the notes written elsewhere rather than trying to enter them all
in one cell.

Vaya con Dios,
Chuck, CABGx3



"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