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!

Tom's solution is a bit simpler than mine.

But again, to display the MMM-YY format, merely format the cells in your Date
column accordingly, rather than convert them to a text string.


--ron