Default date format

Hi,

My Excel is reading date entries as: mm/dd/yyyy

But I would like to enter my dates as: dd/mm/yyyy

I am referring to the actual entry, not the display (ie the value in the formula bar, not the value as displayed in the sheet.) I can change the format as displayed in the sheet, but I cannot change excel to read my inputs differently.

I had this set up in a previous version of excel. I am now using Excel 2003, and can't find how to make the change.

Any help would be much appreciated.

Thanks in advance.

Heski

Excellent.

Thanks very much!