Strange to have a 3-digit year.

If A1 contains:
0081225

In cell B1 enter:
=DATE(2000+LEFT(A1,3),MID(A1,4,2),RIGHT(A1,2))
and format Custom as mmddyyyy to display
12252008

--
Gary''s Student - gsnu200772


"linda" wrote:

I have a database that has a date format of yyymmdd. I need this to be
mmddyyyy. How can I change this?

--
linda