Date Issue with Microsoft Excel

[Adit Shah]

I have a csv file that I open with MS Excel. It contains a date within it in
the format m/d/yy (e.g. 6/7/36). The date is meant to be 2036 but Excel
translates the date to 1936.

My Regional settings in the Control Panel are set up to include any 2 digit
year to be between 1941 and 2040.

In the Excel Options Settings, on the calculation tab, the 1904 Date System
is not checked off. If it is checked off, all the dates in the file change to
a different date.

Could you let me know what could possibly be done to correct this?
Appreciate your help.

Adit

 

[Mike H]

HI<

You seem to be falling foul of the 2029 rule which applies to computed or
programatically generated as opposed to hand entered dates.

have a look here

http://support.microsoft.com/kb/214391

Mike