[X4U] Next dopey Excel question - Solution, I think!

[Brett Conlon]

OK, found it.... I had converted all of my cells to Text cells. While  
they was little info in all cells all was fine. Until one or two cells  
became much larger the issue showed up.

If I convert a problem cell from a Text cell to a Generic cell, the  
hashes disappear. Change it back to a Text cell and the hashes re- 
appear.

Rather strange but an easy fix!

So let this be a warning to you all.  ;-D

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