[X4U] Next dopey Excel question

[Brett Conlon]

Hiya Daly,

I tried it but nothing happened...

You might be able to replicate my issue by entering a buncha text,  
perhaps using the Option-Return between a number of lines into a  
single cell. Eventually the cell (for me at least), when exited, will  
show a single line of hashes for the width of the cell.

For example, the below text in one of my cells will cause the hashes  
to appear when exited but if I remove as much as one character (eg.  
the 't' from the last line) the full remains visible:

dfgkjh gjhfgkjhka fgkljh akjlfgh
asfgdhjkjlhgkljhdkljfh g
dfsgh kjhgfkjlahdfgk hdkjlfhg
kjdfghakjdshfgkljdhfgkjhadkljfgh ajdshfglkjhdfs gkljha sdf
kjgfhijdshfgkljhdfg
skjfgh dfgklhj kjhj
dksfjhg kdjh
dlfjlksdh f
zdkjfhkjfxhg
dksjfghjkfg
djfghkdjfhg
hello t


Coj

On 16/11/2007, at 1:37 PM, Daly Jessup wrote:

> At 13 22  +1100 11/16/07, Brett Conlon wrote:
>> Now that I'm using Option-Return to enter values into a single  
>> Excel cell I've just run across a field returning  
>> ############################## after exiting the field. I thought  
>> this was due to the column not being wide enough to contain the  
>> value, but widening it doesn't make a difference.
>>
>> I have text wrap turned on and all was working nicely until I  
>> placed my last entry in the field.
>>
>> My quick tests indicate it doesn't seem to be line count but more a  
>> character count thing but I believe a cell can contain some 32,000+  
>> characters, though it can only display the first 1024. My entry is  
>> 470+ with spaces. Entering the cell displays the full value...
>>
>> Any idea how to get the full text to display all on its lonesome?
>
> I'm not sure I understand your situation, but might it be that you  
> need to select the row containing that cell, and go to Format/Row/ 
> Autofit?
>
> Daly
> ----------------------
>
> _______________________________________________
> X4U mailing list
> X4U at listserver.themacintoshguy.com
> http://listserver.themacintoshguy.com/mailman/listinfo/x4u
>
> Seven Cent Deals - Great legacy stuff Great Legacy Price http://www.drbott.com/prod/db.lasso?cat=Seven+Cent+Deal