Question: how to change the date format in excel from dot to slash?
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: