I just started using Excel 2007 and have run into a problem not previously
encountered. When I try to type in a date, excel only recognizes it at text.
I've tried entering the date as

18 Nov 07
18-Nov-07
18-Nov-2007
11/18/2007
18/11/2007
November 18th, 2007

and every other combination in between. The most I can get Excel to do is
tell me that I have 2-digit date error, but it still records the input as
text. I've tried changing the format of the cell prior to data entry, but
that doesn't work either.

Please no replies telling me to cut, paste, use the datevalue function, or
any other gyrations. I just want to straight type in the date and have Excel
recognize it as a date.