MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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 Apr-01, or Apr-04 it changes to Apr-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.