Question: how to change the date format to dd/mm/yyyy in excel?
Answer: Go to Format Cells > Custom. Enter dd/mm/yyyy in the available space.