Article ID: 247796 - View products that this article applies to.
This article was previously published under Q247796
This article has been archived. It is offered "as is" and will no longer be updated.
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: February 28, 2014 - Revision: 3.4
Contact us for more help
Connect with Answer Desk for expert help.