How to convert dD.MM.YYYY to date format (mM/DD/YYYY) in Excel?

The typing habit is different for everyone. For instance, some one likes to enter date by using dot such as dd.mm.yyyy. But as we know, the date format in this dd.mm.yyyy cannot be recognized as date in Excel. Have you any ways can quickly convert the date format dd.mm.yyyy to the standard date format mm/dd/yyyy in Excel?

Convert dd.mm.yyyy to dd/mm/yyyy with formula

Convert mm.dd.yyyy to mm/dd/yyyy with Kutools for Excel

Convert dd.mm.yyyy to mm/dd/yyyy with formula

Convert dD.MM.YYYY to DD/MM/YYYY with formula

In some cases, you can to convert dd.mm.yyyy directly to dd/mm/yyyy format, below formula can do you a favor.

Select a blank cell next to the date you want to convert, enter this formula =SUBSTITUTE(A6,".","/") and drag auto fill handle over the cells you want to apply this formula. See screenshot:

Tip: In the above formula, A6 is the date you want to convert, you can change it as you need.

Convert MM.DD.YYYY to MM/DD/YYYY with Kutools for Excel

If you want to convert date format as mm.dd.yyyy to mm/dd/yyyy, you can apply Kutools for Excel's Convert to Date utility, which can quickly convert multiple date to standard date format.

After free downloading and installing Kutools for Excel, please do as below:

1. Select the cells and click Kutools > Content > Convert to Date. See screenshot:

Then you can see all selected cells have been converted to standard date format.
Tip: If the date is no a correct date, the utility will keep the original data.

Convert DD.MM.YYYY to MM/DD/YYYY with formula

If you want to convert the date format dd.mm.yyyy to the standard date format mm/dd/yyyy, you can apply below formula.

1. Select a blank cell next to the date you use, B6 for instance, enter this formula =(MID(A6,4,2)&"/"&LEFT(A6,2)&"/"&RIGHT(A6,2))+0, drag fill handle to the cells you want to use this formula. See screenshot:

2. Now you can see a list of five digits numbers, keep them selected, and go to Home > Number list, and select Short Date to format them as dates. See screenshot:

Then you cans see the non-standard dates have been converted to the standard dates.