Some of the "dates" are probably text, rather than dates. You might try
Data/ Text to Columns, specifying Date MDY as the incoming format at the
last stage of the Wizard.
This may, of course, be a symptom that you've tried to import data that was
in the opposite format from that specified by your Windows Regional Options.
If your data was in mm/dd/yyyy and your Windows settings were looking for
dd/mm/yyyy, some of the numbers will have been misinterpreted (Feb 10th
instead of Oct 1st), but the others (like 12/31/2003) would stay as text.
If that's what's happened, reformatting won't help where you've already
stored the wrong number, so change your Windows settings and reimport the
original data.
--
David Biddulph

"dodgers32" wrote in message
...
I have a list of dates just over 1000 lines long. Dates range from
01/01/1993 to 12/31/2003. When I attempt to convert the column from
01/01/1993 to January 1, 1993 only some of them (about 30) will convert.
The
rest don't change at all. I've tried going to other formats and the same
data changes each time. Help...