xxxxxxxxxx
To change the date display in Excel follow these steps:
Go to Format Cells > Custom
Enter dd/mm/yyyy in the available space.
The dates listed in your spreadsheet should be converted to the new format.
xxxxxxxxxx
Select the cells you want to format.
Press CTRL+1. In the Format Cells box, click the Number tab.
In the Category list, click Date,
and then choose a date format you want in Type.