Thank you David, both for your own solution, and for your recommending I use
Bob's. I'd tried a lot of stuff in a helper column - to no avail until now!
Thanks,
Deb

> Hi Deb,
> Create a helper column, use the fill handle to copy down a formula like:
> =Date(0,Month(a1), 1)
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Debgala" <Debgala@discussions.microsoft.com> wrote in message news:0FFBEB85-10A0-4147-AB79-790D91721B31@microsoft.com...
> > I have a report exported to XL as text file and converted to XL. The dates
> > appear as mm/dd/yy. I want to sort the dates by month & day, but want to
> > ignore the year. Is this possible? How?
> > Thanks,
>
>
>