They're both set to UK settings, i.e. 27/04/2004 for short
and 27 April 2004 for long. Is there somewhere else where
dates are set?


-----Original Message-----
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.
.