The information in this article applies to:
SYMPTOMSWhen 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. CAUSEThis problem occurs when your PivotTable list contains dates earlier than January 1, 1900. Excel does not support date values earlier than January 1, 1900. MORE INFORMATIONExcel 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: XL2000 pivotlist
Keywords : |
Last Reviewed: May 24, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |