Question: how to change date format in google sheets to dd/mm/yyyy?
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.