Article ID: 247796 - View products that this article applies to.
This article was previously published under Q247796
For a Microsoft Excel 98 Macintosh Edition version of this article, see 247799
For a Microsoft Excel 97 version of this article, see 247801
For a Microsoft Excel 7.0 version of this article, see 249033
When you programmatically save the contents of your Microsoft Excel worksheet, some dates that were stored with a four-digit year are truncated to two-digit years.
This behavior occurs when the following conditions are true:
A Microsoft Excel 2000 Programmatic Text Export Update
(http://office.microsoft.com/downloads/2000/xl9p2pkg.aspx)that corrects this problem is available for download from the followint Microsoft Web site:
Cells that contain custom formatting are not affected by this behavior.
Article ID: 247796 - Last Review: January 9, 2007 - Revision: 3.4