change date from 020315 to 03/15/02
"Gary''s Student" wrote:
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?
I got back 08/15/2011 ..... not 03/15/02
|