+ Reply to Thread
Results 1 to 4 of 4

Issues with Pivot Table data displaying 01-01-1900

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    brussels
    MS-Off Ver
    Excel 2010
    Posts
    2

    Issues with Pivot Table data displaying 01-01-1900

    Hello,

    When I create what I believe is a relatively simple pivot table, the data in the "body" of the pivot table is displayed as 01-01-1900 as shown in the image:
    Pivot table issue 1.PNG

    The data I am creating the pivot from is as follows:
    Pivot table issue 2.PNG

    I would like my pivot table to look like the screenshot below so I can easily total up the values to see the most regular failure:
    Pivot table issue 3.PNG

    I am new to pivot tables so maybe I have done something very obvious but any help is apprciated.

    Thanks,
    D

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Issues with Pivot Table data displaying 01-01-1900

    right-click one of the dates, choose number format and change the format to General
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    06-04-2013
    Location
    brussels
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Issues with Pivot Table data displaying 01-01-1900

    Thanks for the quick reply.

    That corrects the issue, however is there a way to configure the default to "General" so I don't always have to "right-click one of the dates, choose number format and change the format to General"?

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Issues with Pivot Table data displaying 01-01-1900

    the default should be general unless the target sheet was preformatted as dates or your Normal cell style has its number format set to Date

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1