Question: how to convert mm/dd/yyyy to dd/mm/yyyy in excel 2010?
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".