Question: how to set date format as dd/mm/yyyy?
Answer: Change Excel Date Format from mm/dd/yyyy to dd/mm/yyyy. To change the date display in Excel follow these steps: Go to Format Cells > Custom. Enter dd/mm/yyyy in the available space.