No need to do that, if you are sending a spreadsheet to somebody with UK
date format it will convert automatically, if you really want to change it
to UK format you need to change the regional setting under windows control
panel otherwise for display you can use a custom format like dd/mm/yy but as
long as you are using US format you need to enter it as mm/dd/yy and it will
display correctly as dd/mm/yy but you cannot enter it as dd/mm/yy without
changing windows date format


--
Regards,

Peo Sjoblom


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