[X4U] Next dopey Excel question

[Daly Jessup]

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
----------------------