Excel defaults to year 2002

Posted by Mike on January 08, 2002 3:03 PM

When ever I put in my excel file a date of Ape-01, or Ape-04 it changes to Ape-02. What causes this and how can I turn it off.

thanks

Posted by seal on January 10, 2002 12:25 AM

sounds like your formating is set to MMM YY
go to formating and change to MMM DD and that should fix that.