Date entry gone haywire in Excel!

When I type a date in a column formatted for dates, and then hit "enter" it
always shows "######". If I put the cursor over the cell, the date will
show, but not in the table. The dates had been entering correctly, and I'm
not aware that I changed any settings. Thanks for any help.

umtraveller, try widening your column

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"umtraveller" <umtraveller@discussions.microsoft.com> wrote in message
news:81CCFC80-17DE-4301-8178-7EB0819A1E6F@microsoft.com...
> When I type a date in a column formatted for dates, and then hit "enter"
it
> always shows "######". If I put the cursor over the cell, the date will
> show, but not in the table. The dates had been entering correctly, and
I'm
> not aware that I changed any settings. Thanks for any help.

Thanks, Paul. That did the trick. I guess until 10/10/2005 I've never used
that many figures in that column. I appreciate your help.

"Paul B" wrote:

> umtraveller, try widening your column
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "umtraveller" <umtraveller@discussions.microsoft.com> wrote in message
> news:81CCFC80-17DE-4301-8178-7EB0819A1E6F@microsoft.com...
> > When I type a date in a column formatted for dates, and then hit "enter"
> it
> > always shows "######". If I put the cursor over the cell, the date will
> > show, but not in the table. The dates had been entering correctly, and
> I'm
> > not aware that I changed any settings. Thanks for any help.
>
>
>

Your Welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"umtraveller" <umtraveller@discussions.microsoft.com> wrote in message
news:1B657DC6-AE5A-4980-A06E-ED84CB1D5452@microsoft.com...
> Thanks, Paul. That did the trick. I guess until 10/10/2005 I've never
used
> that many figures in that column. I appreciate your help.
>
> "Paul B" wrote:
>
> > umtraveller, try widening your column
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "umtraveller" <umtraveller@discussions.microsoft.com> wrote in message
> > news:81CCFC80-17DE-4301-8178-7EB0819A1E6F@microsoft.com...
> > > When I type a date in a column formatted for dates, and then hit
"enter"
> > it
> > > always shows "######". If I put the cursor over the cell, the date
will
> > > show, but not in the table. The dates had been entering correctly,
and
> > I'm
> > > not aware that I changed any settings. Thanks for any help.
> >
> >
> >