2. Select the delimiter in the Text Sorting Wizard 1, and then click Next.
3. Select the default value in the Text Sorting Wizard 2, usually the tab key. Next.
4. Select the date mdy to end in the text sorting wizard 3.
5. Finally, see if the date format has become a real date.