Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2002: 12:00:00 AM Is Displayed for Dates Earlier Than 1900

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

View products that this article applies to.

This article was previously published under Q291081
For a Microsoft Excel 2000 version of this article, see 215965� (http://support.microsoft.com/kb/215965/EN-US/ ) .

↑ Back to the top

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

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.

↑ Back to the top

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

Keywords: KB291081, kbprb

↑ Back to the top

Article Info
Article ID : 291081
Revision : 6
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 371