Microsoft small business knowledge base

Article ID: 215965 - Last Review: February 23, 2014 - Revision: 3.0

This article was previously published under Q215965
This article has been archived. It is offered "as is" and will no longer be updated.
For a Microsoft Excel 2002 version of this article, see 291081  ( ) .


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

  • Microsoft Excel 2000 Standard Edition
  • Microsoft Office PivotTable Component 9.0, run time
kbnosurvey kbarchive kbprb KB215965
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support