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. XL2000: 12:00:00 AM Displayed for Dates Earlier Than 1900

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

View products that this article applies to.

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

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

Article Info
Article ID : 215965
Revision : 3
Created on : 1/1/0001
Published on : 1/1/0001
Exists online : False
Views : 351