How To Change The Date Format 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

For a custom format, select Custom in Format Cells

Enter the desired date format code

Click OK