How to Change the Format of Date in Excel?

Select the cells containing the dates

Right-click the selected cells

Click Format Cells

Go to the Number tab

Select Date

Choose a date format from the list

Click OK

To use a custom format, select Custom

Enter the desired date format code

Click OK

You can also use the Home tab

In the Number group, open the format drop-down

Choose Short Date, Long Date, or More Number Formats

Apply the selected format to the cells

Suggested for You

Trending Today