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

--
johnD30

Check your Windows Regional Settings. It looks to me like the date format is
set to year, month, day.

Regards,
Fred

"JohnD30" wrote in message
...
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

--
johnD30

Visit www.ExcelGoodies.Com

---
frmsrcurl: http://msgroups.net/microsoft.public...isplayed-dates