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
