Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    date format wont group (2003)

    the date format in this file does not permit grouping on a pivot table where I wanted to group by years, It seem to behave as an alpha numeric value.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: date format wont group (2003)

    They *are* text values. It doesn't matter that the format of the cells is a date format, the values are text. You'll have to convert them to valid date values.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: date format wont group (2003)

    you already answered me by
    The values in the Date PSSE column on the source sheet are not date values but text values, as you can see by their being left-aligned. You can correct this as follows:
    - Copy it to the clipboard (Ctrl+C).
    - Select new colume the cells with dates.
    - Select Edit | Paste Special...
    - Select the Add option and click OK.
    Now update the pivot table and format the data item as a date.
    thanks

Posting Permissions

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