How do I convert this date "060426" to "4/26/2006"
G Gary Brown Apr 24, 2006 #2 Assuming the 060426 is in cell A1, type the following formula:- =DATE(20&LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2)) Then format this cell with a format M/DD/YYYY
Assuming the 060426 is in cell A1, type the following formula:- =DATE(20&LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2)) Then format this cell with a format M/DD/YYYY
