Date entry gone haywire in Excel!

U

umtraveller

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

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
 
U

umtraveller

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

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
 
Top