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!

"Ron Rosenfeld" wrote:

On Wed, 22 Jun 2005 06:42:01 -0700, "GEORGIA"
wrote:

Hi,
I have a spreadsheets with ticket numbers and the date it was submitted. It
is in medium date format (3/18/2005). I have used this formula:
=text(A2,"MMM-YY") to conver it to Mar-05.
now i have a column with MMMYYY date, however, it will not let me sort it.
It is sorting alphabetically, and not in the order of the date. so I have
Feb-04,Feb-05, Jan-04,Jan-05 and so on. How can I sort this by month then
year?

Thank you!

I am assuming your dates are in column A2:A1000, and that A1 contains an
appropriate header (e.g. Date)

Here is one method:

Insert two columns to the left of column A (the original column A will now be
Column C).

A1: Month
B1: Year

A2: =MONTH(C2)
B2: =YEAR(C2)

Copy/Drag these formulas down to row 1000.

Select a cell in the table; then Data/Sort

Sort by Month; Ascending
then by Year; Ascending

Finally, you can delete columns A & B.

If you want the dates in the DATE column to appear as mmm-yy then select that
column and Format/Cells/Number/Custom Type: mmm-yy


--ron