G
Guest
I have my cells fromatted as "date" 2-MAR-81. When I sort the column it
sorts it by the year either ascending or descending depending on my
selection. I want excel to sort the info in the column by the month rather
than the day or year. I have 485 "dates" in 1 column and I would like it to
sort by Month then Day. I tried to do this by going:
Data
Sort
Options
First Key Sort order
Jan,Feb,Mar Etc.
But it still won't work it keeps sorting the column by the year. PLEASE
someone help me out!
sorts it by the year either ascending or descending depending on my
selection. I want excel to sort the info in the column by the month rather
than the day or year. I have 485 "dates" in 1 column and I would like it to
sort by Month then Day. I tried to do this by going:
Data
Sort
Options
First Key Sort order
Jan,Feb,Mar Etc.
But it still won't work it keeps sorting the column by the year. PLEASE
someone help me out!