Date Formatting

I

Ivan Teodorovic

I'm trying to convert a text format of "mmddyy" to a date
format of "mm/dd/yy".

Please advise!

Thanks.
 
A

Anon

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.
 
Top