Microsoft has released a patch that fixes a formatting problem when exporting Excel 2000 files to .txt documents. On machines running a Microsoft OS earlier than Windows 2000, four-digit year entries are automatically truncated to two-digit entries, regardless of formatting applied within Excel.
This behavior occurs only when users employ a macro or procedure to export to a text file, not during manual saves to a text file format. If your users are using Visual Basic for Applications to export files to .txt, .prn, .csv, or .dif formats (and you are using a pre-Windows 2000 OS), you need to install an update released by Microsoft. For more information, read the Microsoft Knowledge Base article 247796, XL2000: Programmatically Exporting Text File Truncates Dates:
