I wonder if anyone can help me with this as it's driving me mad.

I have Excel 2003 running under Vista Home Premium and everything was
fine until a few days ago. I have spreadsheets with dates entered in
the following format:

Date: 14-Mar-01 - so when I enter 16/11/07 it appears in the cell as
16-Nov-07. The locale is: English (United Kingdom)

A couple of days ago I installed a program which needs to change my
regional settings to US while it is running and then changes them back
when I exit. Everything works fine and all the regional settings are
changed back to UK after closing this software.

However, in Excel, all new sheets now open up with the date set to
English (US). Even if I format the cell to English (UK), I canot enter
the dates as I did before. If I now enter 16/11/07 it just stays in
this format. I have to enter the date in US format, 11/16/07 before it
will change to 16-Nov-07, even thought the cell is set to UK format.

I am sure the software I installed has changed some variable but how
do I change it back?


Thank you.