Excel 2007 displayed dates

  • Thread starter Thread starter JohnD30
  • Start date Start date
J

JohnD30

When I enter dates in the Uk english format (dd/mm/yyyyy) in Excel 2007, even
though they are formatted to display dd/mm/yyyy, they are dispayed in the US
english format (mm/dd/yyyy). The formula bar shows that the cell contains a
date in the UK format as entered. The language setting in Excel Options is UK.

I wrote a macro containing an InputBox requesting a date, having previously
defined the variable for this input as Date. The input is entered in the UK
format but when assigning the value of this variable to a cell, it is
displayed in US format. Not only is it displayed contrary to the custom
format, but the content is rubbish. For example, when the date 31 October
2009 is entered into the input box in the UK format, 31/10/09, it is
transposed to a date value of October 09, 1931 in the formula bar and
displayed in the cell as 10/09/31.

Any ideas???
Operating system: Windows Vista
 
Check your Windows Regional Settings. It looks to me like the date format is
set to year, month, day.

Regards,
Fred
 
Back
Top