Bug Report

[Adrian-P]

Can't seem to find where to submit bug reports... so I'll try here:

Inconsistent MDY DMY translation in Excel 2003
Behaviour different from previous versions (97? onwards)
--------------------------------------------------------------------

Win XP Pro, all regional settings (including system account and Non-unicode)
as UK
Application.International(xlDateOrder) returns 1 (day/month/year)

With Sheet1, set cell 'A1' formatting to Date,'14 March 2001'
Type in 1/7/2006 as expected this correctly gives 01 July 2006
Go to VBA immediate pane
?Range("A1").Value Prints '01/07/2006', as expected

Range("A1").Value=CDate("01/07/2006") A1 correctly contains '01 July 2006'

Range("A1").Value="01/07/2006" Incorrectly changes cell A1 to '07
January 2006'
In Excel 97 etc, A1
would still contain '01 July 2006'

?Range("A1").Value now prints '07/01/2006'




----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...8c329fa&dg=microsoft.public.excel.crashesgpfs