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

Article translations Article translations
Article ID: 291081 - View products that this article applies to.
This article was previously published under Q291081
This article has been archived. It is offered "as is" and will no longer be updated.
For a Microsoft Excel 2000 version of this article, see 215965.
Expand all | Collapse all


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.


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.


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.


Article ID: 291081 - Last Review: February 27, 2014 - Revision: 2.4
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Office Web Components
kbnosurvey kbarchive kbprb KB291081

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com