Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Pivot Table: Group: Date - Error in Conversion

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well, day two and I have another issue dealing with the same data I have been using in another posting.

    I am working with a Pivot Table trying to sum a range of data by years. The data is entered as mm/yy. When I try to group the data together by year to get a sum for that year, the grouping changes the date, but incorrectly.

    For example:

    00
    01
    02
    99

    These dates change to:

    1900
    1901
    1902
    1999

    I have checked my cell content and the cells are Custom/mmdd.

    Any suggestions?

    Thanks again,
    Jason

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Brampton
    Posts
    328
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You have to change the way two-digit years are interpreted. For Win98 or 2000 go to Control Panel|Regional Settings(Options)|Date and change the upper limit for the century.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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