with something like:
08/06/2008
in A1

In cells B1 thru E1 enter:
=DATEVALUE(A1)
=YEAR(B1)
=MONTH(B1)
=DAY(B1)


--
Gary''s Student - gsnu200798


"frogstyle" wrote:

I'm looking for a way to take a list of dates that are being cut and pasted
from an Access Database into excel and separate it so I can sort by Month,
Day, Year. The data seems to be recognized in Excel as a date because it
sorts by the the year. The format is mm/dd/yyyy. When I try to change the
format to anything else, it won't allow the change.