New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Formatting›Change date format

Google Sheets · Verified tutorial

Change date format in Google Sheets

Format A2:A4 as dates using the custom pattern mmmm d, yyyy.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Format A2:A4 as dates using the custom pattern mmmm d, yyyy.

Step-by-step

1

Select the targetFormat A2:A4 as dates.

2

Apply the changethe custom pattern mmmm d, yyyy.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A2:A4 uses the requested long-date pattern.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A2:A4 and repeat the final action. A2:A4 uses the requested long-date pattern.

Example spreadsheet data

This is the clean fixture used for the verified run.

Date

46235

46249

46265

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Format A2:A4 as dates.
Apply the change. the custom pattern mmmm d, yyyy.
A2:A4 uses the requested long-date pattern.