How to Change Date Format in Google Sheets

Created with Trainn AI

Here's a step-by-step walkthrough on how to change date format in Google Sheets

1. Select the cells containing the dates.

Screenshot of how to change date format in Google Sheets step 1

Screenshot of how to change date format in Google Sheets step 2

Screenshot of how to change date format in Google Sheets step 3

4. Select "Custom date and time".

Screenshot of how to change date format in Google Sheets step 4

5. Choose your preferred date format.

Screenshot of how to change date format in Google Sheets step 5

6. Then, click the "Apply" button.

Screenshot of how to change date format in Google Sheets step 6

Congrats! You have successfully changed the date format in Google Sheets!

Explore More