Microsoft KB Archive/291081

= XL2002: 12:00:00 AM Is Displayed for Dates Earlier Than 1900 =

Article ID: 291081

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Office Web Components

-



This article was previously published under Q291081



For a Microsoft Excel 2000 version of this article, see 215965.



SYMPTOMS
When you export your Microsoft Office PivotTable list to Microsoft Excel, 12:00:00 AM is displayed in the PivotTable where you expect a date to be.



CAUSE
This behavior occurs when your PivotTable list contains dates earlier than January 1, 1900. Excel does not support date values earlier than January 1, 1900.



MORE INFORMATION
Excel converts dates earlier than January 1, 1900 to a value of zero. The value of 12:00:00 AM that you see is the result of the default formatting that Excel applies to the number.

Additional query words: pivotlist prb XL2002

Keywords: kbprb KB291081

-

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

© Microsoft Corporation. All rights reserved.