Hi. I've created a spreadsheet Book1.xls, set the dateformat, set a few
cells, but the date displayed is not correct if the day number <= 12.

My Windows locale is "English (United States)", short date is "6/15/2007",
and location is "United States". Created a new xls file Book1.xls. Select
column A and set the format to Date - English (United Kingdom) - 14/03/2001.

In cell A2 enter "11/06/2007". The cell contents bar at the top shows the
value is "11/6/2007" (which is fine), but the value displayed value in A2
"06/11/2007" which is not correct. Interestingly, if you press F2, then the
in place cell editor shows "11/6/2007" (which is the value in the contents
bar at the top).

In cell A3 enter "12/6/2007". The cell contents bar at the top shows
"12/6/2007", but the value displayed in A3 is "06/12/2007" which is not
correct.

In cell A4 enter "13/06/2007". The cell contents bar at the top shows
"13/6/2007", and the value displayed in A4 is also "13/6/2007" which is good.

Why is it that if the day number 12 then the format works fine? But if
day number <= 12 the format reverts to US format.

Thanks in advance.