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 ...

Excel is seeing the serial date. Put separators between your numbers,
e.g. / or -. Then you'll see 2 Feb 06.

Excel stores dates as sequential serial numbers so they can be used in
calculations. By default, January 1, 1900 is serial number 1, and
January 1, 2008 is serial number 39448 because it is 39,448 days after
January 1, 1900.


--
daveproberts
------------------------------------------------------------------------
daveproberts's Profile: http://www.excelforum.com/member.php...o&userid=33244
View this thread: http://www.excelforum.com/showthread...hreadid=530677

"Barbara" wrote in message
...

[nothing, but the question was in the subject line]

Excel counts in days. 1 is 1/1/1900, 22806 is 22805 days later, which is
9/6/92 (but you've got your date in a funny format).
--
David Biddulph