Question: how to change date format to dd/mm/yyyy in google sheets?
Answer: Click the date format near the bottom of the menu. Google Docs formats the cell's value in the "MM/DD/YYYY" format. You can choose "More Formats" from the menu to see and select other date formats.