I Ivan Teodorovic Sep 17, 2003 #1 I'm trying to convert a text format of "mmddyy" to a date format of "mm/dd/yy". Please advise! Thanks.
I'm trying to convert a text format of "mmddyy" to a date format of "mm/dd/yy". Please advise! Thanks.
A Anon Sep 18, 2003 #2 This will result in a TEXT format "mm/dd/yy". To get an actual date, try =DATE("20"&RIGHT(A1,2),LEFT(A1,2),MID(A1,3,2)) and format the cell with date format mm/dd/yy.
This will result in a TEXT format "mm/dd/yy". To get an actual date, try =DATE("20"&RIGHT(A1,2),LEFT(A1,2),MID(A1,3,2)) and format the cell with date format mm/dd/yy.
