Tags: based, date, excel, grouped, microsoft, msdn, numerically, pivot, software, sort, sorted, sorting, table
Pivot Table, Date Sorting?
On Microsoft » Microsoft Excel
1,519 words with 1 Comments; publish: Thu, 22 May 2008 23:42:00 GMT; (30646.88, « »)
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?
http://excel.itags.org/q_microsoft-excel_352984.html
All Comments
Leave a comment...
- 1 Comments
- 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" <anonymous.excel.itags.org.discussions.microsoft.com> wrote in message
news:A263602F-8DFB-438B-8BD3-F55EA03772BF.excel.itags.org.microsoft.com...
> 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?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003
#1; Thu, 22 May 2008 23:44:00 GMT