Question: how to change date format in google sheets from mm/dd/yyyy to dd/mm/yyyy?
Answer: Select the cell with the date entered in default format i.e. mm/dd/yyyy. Go-to "File" [top command bar] and select Numbers [1st option] Within selection go-to the bottom, you'll find: More Formats. Under More Formats section: you'll find More date and time formats.