Try this formula instead:

=DATE(2000+LEFT(A1,2),--MID(A1,3,2),RIGHT(A1,2))
--
Gary''s Student - gsnu200770


"CHARI" wrote:



"Gary''s Student" wrote:

Assuming you original data is formatted as Custom yymmdd, change the format to:
mm/dd/yyyy
--
Gary''s Student - gsnu200770


"CHARI" wrote:

how do I change the format in this date?


No, it's not formatted that way. The original format was 1020315 and I
removed the 1 but I can't get the formatting to change. This was originally
a text file I imported. Should I import it different or can I change it as
is?