On Wed, 22 Jun 2005 19:09:06 -0700, "GEORGIA"
wrote:

I apologize for not being clear..
i guess I wanted to convert the long date 1-11-05 to Jan-05 for pivot table
purpose.
If i change the format on 1-11-05 as MMM-YY... it will show up as MMM-YY but
when you click on that actual cell, it is still 1-11-05, therefore when I do
the pivot table, it will not group all Jan-05 together. my pivot shows in
alphabetic order instead of Date order. For example: April04,April05,
Feb04,Feb05 and so on.
Someone help! Thank you!

If you are using a pivot table, that makes it much easier. For example, using
two columns, with a list of dates in one column, and a "ticket number" in the
adjacent column, I generated a pivot table. Format cells in Date column as
mmm-yy

1. Drag Dates to Row area
2. Drag Ticket Number to Data area and select to do Count (Field Settings)
3. Click in Row area, Right Click/Group and Show Detail/Group/ select Months
and Years.

This will initially set up with Years in the First Column and Months in
the Second column like this:

2004 Jan 34
Feb 24
Mar 32
Apr 30
May 26
Jun 37
Jul 28
Aug 35
Sep 23
Oct 33
Nov 21
Dec 24
2005 Jan 32
Feb 21
Mar 36
Apr 32
May 29
Jun 32
Jul 30
Aug 30
Sep 32
Oct 32
Nov 40
Dec 31
2006 Jan 36
Feb 19
Mar 27
Apr 31
May 32
Jun 30
Jul 26
Aug 26
Sep 31
Oct 37
Nov 37
Dec 28


=============
However, you can drag the Years column to the right of the months column and it
will then sort as you have specified:

Count of Ticket Number
Date Years Total
Jan 2004 34
2005 32
2006 36
2007 26
2008 29
Jan Total 157
Feb 2004 24
2005 21
2006 19
2007 25
2008 28
Feb Total 117
Mar 2004 32
2005 36
2006 27
2007 30
2008 31
Mar Total 156
============================

No formulas or anything special required!



--ron