You could convert the data to real dates and just format them to show the abbreviated month name. It might even be useful when you go into the next year. sandran wrote: I'm having a problem with filtering by abbreviated months in Excel. For example, I will have a list of cells with the month: Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov