Question: how to change date format in excel from mm/dd/yyyy to dd/mm/yyyy in windows 7?
Answer: 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".