"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?