How to handle this Date formatting in Excel

I use MS Excel 2007.

When I type in date as 2/3/2009, it gets typed as 3/2/2009
i.e. DD/MM/YYYY to MM/DD/YYYY

Attached is file for your information.

I have even formatted the Cells in that particular column to Date Format under British (UK) DD/MM/YYYY.

I want dates in DD/MM/YYYY format only. How do I handle this ?

My Regards - Jack

Select the column and go to Data|Text to Columns

Then skip to the 3rd window and in the column data format area choose Date and DMY from the drop down.

Click Finish