Question: how to change date format in excel with dot?
Answer: Please enter this formula: =SUBSTITUTE(A2,".","/") ... 
Then drag the fill handle down to the cells that you want to contain this formula, and the dot date has been converted to the slash date format, see screenshot: