View Single Post
  #1   Report Post  
CraigH
 
Posts: n/a
Default Date Format Behavior

In an Excel 2000 workbook, when the date "5/13/05" is entered in a cell, upon
leaving the cell the date changes to "5/13/2004."

The computer date is set to the correct year. The Excel Date format is set
for the appropriate format.

Any ideas on what can cause this strange behavior?

Thanks,
Craig.