Ensure your regional language and keyboard are set to English UK .
From your open Excel spreadsheet, right click on the cell in question and select Format cells.
The Format Cells window is now displayed.
Under the Number tab / Category, select Custom and in the right pane, select dd/mm/yy
Click OK to apply the changes.
N.B. This may vary slightly depending on your version of Excel.
exo