What are the 'Long' and 'Short' date formats in regional settings on your PC? Excel uses the regional settings by default and the default for Excel is US i.e. consistent with mm/dd/yyyy. You need to set them to dd/mm/yyyy

Look into: START | SETTINGS | CONTROL PANEL + REGIONAL OPTIONS on the 'Date' tab.