Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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" wrote in message ... 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. |
#3
|
|||
|
|||
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" wrote in message ... 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. |
#4
|
|||
|
|||
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" wrote in message ... 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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Launch excel showing today's date | Excel Discussion (Misc queries) | |||
How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions |