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