Microsoft KB Archive/247796

= XL2000: Programmatically Exporting Text File Truncates Dates =

Article ID: 247796

Article Last Modified on 1/9/2007

-

APPLIES TO

 Microsoft Excel 2000 Standard Edition, when used with:  Microsoft Windows 95

 Microsoft Windows 98 Standard Edition

 Microsoft Windows NT 4.0 

-

<div class="notice_section">

This article was previously published under Q247796

<div class="notice_section">

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.

<div class="symptoms_section">

SYMPTOMS
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.

<div class="cause_section">

CAUSE
This behavior occurs when the following conditions are true:  You use the SaveAs method to save the contents of your Excel worksheet.

-and-

</li> You specify one of the following parameters for the FileFormat argument of the SaveAs method:

 xlCSV</li> xlCSVMac</li> xlCSVMSDOS</li> xlCSVWindows</li> xlCurrentPlatformText</li> xlDIF</li> xlTextMac</li> xlTextMSDOS</li> xlTextPrinter</li> xlTextWindows</li> xlUnicodeText</li></ul>

-and-

</li> The Short date style setting under Regional Settings in Control Panel is set to a format displaying four-digit years.</li></ul>

By design, Excel uses the default Short date style setting (m/d/yy) for the U.S. English version of Windows to determine the format for exporting your worksheet to one of the file formats listed above. This maintains consistent, predictable automation results, regardless of locale settings.

<div class="resolution_section">

RESOLUTION
A Microsoft Excel 2000 Programmatic Text Export Update that corrects this problem is available for download from the followint Microsoft Web site:

http://office.microsoft.com/downloads/2000/xl9p2pkg.aspx

<div class="moreinformation_section">

MORE INFORMATION
Cells that contain custom formatting are not affected by this behavior.

Additional query words: XL2000 y2k

Keywords: kbhotfixserver kbqfe kbdownload kbdtacode kbofficeupdate kbpending kbprb KB247796

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.