check control panel-regional and language options
it may be trying to go dd/mm/yy instead

"yakalo" wrote:

I've run into a very odd date format problem in excel 2003: When I type in a
date as MM/DD/YY and the date is less than 12 (e.g. 04/11/07), excel
automatically changes the format to MM/DD/YYYY, after which I can play with
the date format to get it to look how I want (e.g. 11-Apr-07).

However, if the date is greater than 12 (e.g. 04/13/07) excel leaves the
cell as text, and its format cannot be changed to a date, even by going to
"format cell" and selecting "date." Has anyone else noticed this? Try it
with this example and you'll see what I mean!

It may seem like a minor glitch, but big problems arise when downloading
banking data (i.e. the first 12 days of the month have different date formats
than the rest, and can therefore not be sorted by date), and when trying to
export (when exporting to .qif and uploading to Quicken the two date formats
import differently).

Help!