wrapping text in excel
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
|