XL2000: 12:00:00 AM Displayed for Dates Earlier Than 1900

Article ID: 215965 - View products that this article applies to.
This article was previously published under Q215965
For a Microsoft Excel 2002 version of this article, see 291081
(http://support.microsoft.com/kb/291081/EN-US/ )
.
Expand all | Collapse all

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.
Back to the top | Give Feedback

CAUSE

This problem occurs when your PivotTable list contains dates earlier than January 1, 1900. Excel does not support date values earlier than January 1, 1900.
Back to the top | Give Feedback

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.
Back to the top | Give Feedback

Properties

Article ID: 215965 - Last Review: October 6, 2003 - Revision: 3.0
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Office PivotTable Component 9.0, run time
Keywords: 
kbprb KB215965
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top