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