How to sort in Excel

Discussion in 'Mac Apps and Mac App Store' started by TonyBaloney, Jul 8, 2010.

  1. TonyBaloney macrumors regular

    Joined:
    May 7, 2007
    Location:
    Katy, TX
    #1
    Hey I was wanting to know how to sort a list of birthdays in excel by month and day only (Not including years); I also tried to add only the month and day data but it kept sticking 2010 on the end. Any tips? thanks
     
  2. psxguru macrumors 6502a

    Joined:
    May 19, 2006
    #2
    Change the formatting for the column (format | cells) to a date format without a year (or your own custom format)

    Go to data | sort and choose the column you want sorted by.
     

Share This Page