[X4U] Next dopey Excel question

[Brett Conlon]

Hiya Stroller,

Yes, I initially thought it was a depth thing and made the row deeper  
(as deep as I could drag it) but no change - one line of hashes at the  
top.

Like I mentioned, if I copy the contents of the offending cell and  
paste it into a brand new document's cell it reads fine. There must be  
some sort of formatting going on in my document.

OK, I've got it working - to get myself out of trouble, I copied the  
full contents from the cell. I then selected and deleted the cell,  
double clicked inside the new cell and hit paste. When I exited the  
cell the text wrap was working and I could see the entire contents of  
the cell - no more hashes.

So at least the strange formatting must have been just limited to the  
cell, not the document.

I'll get to the bottom of this sooner or later. I'll report it when  
I've found it.

Cheers,

Coj

On 16/11/2007, at 11:58 PM, Stroller wrote:

>
> On 16 Nov 2007, at 02:22, 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.
>
> If you're using Option-Return to enter multiple lines into a single  
> Excel cell I might expect the problem to be that the cell isn't tall  
> enough, not that it isn't wide enough.
>
> Stroller.
> _______________________________________________
> X4U mailing list
> X4U at listserver.themacintoshguy.com
> http://listserver.themacintoshguy.com/mailman/listinfo/x4u
>
> Seven Cent Deals - Great legacy stuff Great Legacy Pricehttp://www.drbott.com/prod/db.lasso?cat=Seven+Cent+Deal