I have an Excel 2000 spreadsheet and when I type the date 1/12/05, the date will change to 0-Jan-1900. However, when I place my cursor on the field, the field shows correctly. I looked at the settings within the Control Panel, Regional & Language Options and the Short Date and Long Date are correct. Any suggestions??