Excel convert date format dd.mm.yy to date

If you want to convert a date in toe format dd.mm.yy to a supported date, make a cell containing:

=(MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A1,2))

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.