Hi Barbara,
And what did you expect to get for a date.

Internally Excel stores dates as the numbers of days past Dec 31, 1899
(incorrect number but that is besides the point).

Having incorrect data, the next step would be know if you entered those
as TEXT or as NUMBERS. At least we can tell from the 28 that you
have a US format mmddyy

You might be able to quickly make it look better with a helper column
=TEXT(A1+0, "00/00/00")
but no way would they become dates.


But actually why continue, Chip Pearson has a page on fixing
Date And Time Entry
http://www.cpearson.com/excel/DateTimeEntry.htm

and would point out that 11106 would be ambiguous as to
whether it was meant to be 01/11/06 or 1101/06 (US format)

More information on Date and Time
http://www.cpearson.com/excel/datetime.htm
http://www.mvps.org/dmcritchie/excel/excel.htm/datetime

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Barbara" wrote in message ...