Philip Reece-Heal wrote:
Assuming the date in your sheet is numerical and not text, then a
possible solution is to create a column next to your date column (and
assuming your date column is A) in the new column enter the formula
=MONTH(A1) which will give you the month (numbered 1 to 12). Copy
formula down the rows you want and sort on that column.

You could then hide the new column or delete it altogether.

Hope that is of help

Philip[


"Saz" wrote in message
ps.com...
Hi, The file has date formate as MM/DD/YYYY and I want to keep it that
way. Is there anyway the file can be sorted by only MM? I am trying to
sort by Jan, Feb, March...... November, December together.

Thanks,
Saz



Not very elegant, but when I need to do this I just break the date into
3 columns month,day,year by using text to columns and format it as text.

gls858