I have an additional question regarding the date as text. I have imported
data and it automatically converts to this format except pre- 2k the address
is correct, post 2k it converts to DD-MMM. The only way I've been able to
fix this is to use the SHEET.xlt instead of BOOK.xlt and then set the errors
to allow two digit years.



"GEORGIA" wrote:

this converts to format (012005)
i want to conver it to MMM-YY which is Jan-05 or even Jan05 then sort.
any help would appreciated it.
thank you

"Tom Ogilvy" wrote:

=Text(A2,mmyyyy)

--
Regards,
Tom Ogilvy


"GEORGIA" wrote in message
...
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!