Date entry gone haywire in Excel!

[Guest]

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.

 

[Paul B]

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

 

[Guest]

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]

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