View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Selvarathinam
 
Posts: n/a
Default Sorting Month Only

Put the below formula & copy the same till u need.

=TEXT(A1,"mm/dd")

01/01/02 = "01/01"

the above formula will provide u as "01/01", if u need the result as
JAN/01, then use "mmm/dd", for January/01 then use "mmmm/dd"

Hope the above solution will help u.

----
Selvarathinam.