how to change date format in excel with slash?
['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:']