VoG
Legend
- Joined
- Jun 19, 2002
- Messages
- 63,650
I live in the UK where the convention is to write dates as dd/mm/yy. However, Excel is determined to use the convention mm/dd/yy. I have verified this by
MsgBox(Application.International(XlDateOrder))
which returns 0, the code for mm/dd/yy.
The effect is that if I enter 29/3 (to mean 29 March) in a cell it will appear as "29/3" whatever date format I set. If I try e.g. =WORKDAY() on that cell I get #VALUE! If I enter 3/29 all is OK.
I have checked in Control Panel, Regional and Language settings and in Date and Time and all appears OK.
What have I missed or where am I going wrong? I am sure that this has not always occurred but as I don't use date functions that often I cannot pinpoint when things changed.
Excel 2002 SP2 and Windows XP SP1.
This message was edited by VoG™ on 2002-10-05 12:33
MsgBox(Application.International(XlDateOrder))
which returns 0, the code for mm/dd/yy.
The effect is that if I enter 29/3 (to mean 29 March) in a cell it will appear as "29/3" whatever date format I set. If I try e.g. =WORKDAY() on that cell I get #VALUE! If I enter 3/29 all is OK.
I have checked in Control Panel, Regional and Language settings and in Date and Time and all appears OK.
What have I missed or where am I going wrong? I am sure that this has not always occurred but as I don't use date functions that often I cannot pinpoint when things changed.
Excel 2002 SP2 and Windows XP SP1.
This message was edited by VoG™ on 2002-10-05 12:33