software

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 quot;###############etc.quot; 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 quot;notesquot;, 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
quot;cpquot; wrote:

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

quot;CLRquot; wrote:

gt; With those large quot;notesquot;, you might consider just a hyperlink in your
gt; database to the notes written elsewhere rather than trying to enter them all
gt; in one cell.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;cpquot; wrote:
gt;
gt; gt; Regarding a worksheet with columns A-E; Columns A-D are for name, company,
gt; gt; status, phone #; column E is for notes, some of which are lengthy. I
gt; gt; understand that the autofit height, wrap text formatted cells allow for 32767
gt; gt; characters, and display only 1000. My problem is that all of a sudden in one
gt; gt; of the E column cells, I entered notes, which all showed up as I was typing;
gt; gt; but, when I progressed to the next row, first cell, the cell I just left
gt; gt; appeared as quot;###############etc.quot; What is with this?
gt; gt; Also is there a way to format the notes column to extend beyond the
gt; gt; 32767/1000 character restriction --- or --- should I be using another
gt; gt; 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?

quot;Dave Petersonquot; wrote:

gt; Try formatting the cell as General.
gt;
gt; Then add alt-enters (to force new lines within the cell) every 80-100
gt; characters.
gt;
gt; You'll see way more than what's documented in help.
gt;
gt; cp wrote:
gt; gt;
gt; gt; Regarding a worksheet with columns A-E; Columns A-D are for name, company,
gt; gt; status, phone #; column E is for notes, some of which are lengthy. I
gt; gt; understand that the autofit height, wrap text formatted cells allow for 32767
gt; gt; characters, and display only 1000. My problem is that all of a sudden in one
gt; gt; of the E column cells, I entered notes, which all showed up as I was typing;
gt; gt; but, when I progressed to the next row, first cell, the cell I just left
gt; gt; appeared as quot;###############etc.quot; What is with this?
gt; gt; Also is there a way to format the notes column to extend beyond the
gt; gt; 32767/1000 character restriction --- or --- should I be using another
gt; gt; softwear program? Thanks, cp
gt;
gt; --
gt;
gt; Dave Peterson
gt;

You could put the large notes on quot;otherquot; 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
quot;cpquot; wrote:

gt; This spreadsheet is formatted to present updated information to our clients,
gt; so would the hyperlink work. In other words, the spreadsheet IS our only
gt; place for these notes, so that we do not have to double our work. Do you
gt; know of a better program for us to consider?
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; With those large quot;notesquot;, you might consider just a hyperlink in your
gt; gt; database to the notes written elsewhere rather than trying to enter them all
gt; gt; in one cell.
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;cpquot; wrote:
gt; gt;
gt; gt; gt; Regarding a worksheet with columns A-E; Columns A-D are for name, company,
gt; gt; gt; status, phone #; column E is for notes, some of which are lengthy. I
gt; gt; gt; understand that the autofit height, wrap text formatted cells allow for 32767
gt; gt; gt; characters, and display only 1000. My problem is that all of a sudden in one
gt; gt; gt; of the E column cells, I entered notes, which all showed up as I was typing;
gt; gt; gt; but, when I progressed to the next row, first cell, the cell I just left
gt; gt; gt; appeared as quot;###############etc.quot; What is with this?
gt; gt; gt; Also is there a way to format the notes column to extend beyond the
gt; gt; gt; 32767/1000 character restriction --- or --- should I be using another
gt; gt; gt; softwear program? Thanks, cp