Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
XL97: Programmatically Exporting Text File Truncates Dates
Article ID: 247801 - View products that this article applies to.
This article was previously published under Q247801
When you programmatically save the contents of your Microsoft Excel worksheet, some dates that are stored with a four-digit year are truncated to two-digit years.
This behavior occurs when the following conditions are true:
To correct this problem, download and install the latest update for Excel 97. The latest update includes this and all other Excel-specific updates that have been released since the latest service release (SR) of Office. The files included in this update will be included in any later SR or patch. To upgrade to the latest patch or for more information about the history of Excel 97 patches, please click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/232652/EN-US/ )XL97: Overview and History of Excel Patches
Cells that contain custom formatting are not affected by this behavior.