Pivot Table, Date Sorting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot table with the data grouped by year,month, date. Year and Month sort ok, but date seems to be sorted numerically based on the day. I get the following: 10 - 30 followed by the dates 1 - 9. I've changed the date format to several different formats with no luck. I've double-checked to sort order and everything looks ok. Any Ideas?
 
Sounds like they are not real dates, but are in fact either a numerical representation of
a date or text. They need to be real dates in a format that Excxel recognises to sort
properly, otherwise you will get exactly the problem you have got.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



Steve said:
I have a pivot table with the data grouped by year,month, date. Year and Month sort ok,
Click to expand...
but date seems to be sorted numerically based on the day. I get the following: 10 - 30
followed by the dates 1 - 9. I've changed the date format to several different formats
with no luck. I've double-checked to sort order and everything looks ok. Any Ideas?
 
Back
Top