[X4U] Next dopey Excel question

[Paul Moortgat]

You can go to <http://exceltips.VitalNews.com> for help.  You also  
can subscribe for free weekly tips.

Paul Moortgat

On 17 Nov 2007, at 11:40, Brett Conlon wrote:

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