Excel 2007 displayed dates

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
 
F

Fred Smith

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

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default date format (with shortcut keys) 2
Excel is changing date format incorrectly 7
Convert dates stored as text 2
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1
Convert Date to MMYY format 2
Excel 2002: How to make the date format uniform ? 1
date format 1
In excel when inputting dates 10/4/04 (10/april/04) data converts. 1

Top