Your Windows Short Date format is set to yy/mm/dd

For Windows XP:

StartControl PanelDate, Time, Language and Regional OptionsChange the format od Numbers, dates and timesCustomizeDate
tabShort date format


--
Kind regards,

Niek Otten
Microsoft MVP - Excel
--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"tc" wrote in message ...
| hi. whenever i try to enter a date in a particular cell for eg.
| 14/11/07 (i.e. 14 November, 2007) the date that is displayed in the
| cell is 7-Nov-14 (i.e. 7 November, 2014) !. i have tried all possible
| options in the format cells section and even to the extent of changing
| the system regional date settings. Please help!