Question: how to change date format from mm/dd/yyyy to dd/mm/yyyy in excel 2016?
Answer: where the MM-DD-YYYY string is in cell A2. If you want to change the format in excel ,Click 'Home' Tab in the Ribbon-> In 'number 'Group->Choose 'more number format'-> 'custom'->change the 'type' as "DD-MM-YYYY". If you want to change the format when export it from SQL Server Database to excel.