Question: how to change the date format in google sheets?
Answer: On your computer, open a spreadsheet in Google Sheets. Highlight the data you want to format. Click Format Number More Formats. Click More date and time formats. Search in the menu text box to select a format. ...  Click Apply.