Ken

Dates are serial numbers like 39133 which is formatted to look like 02/20/2007
and you can't filter them as you want by entering 01, 02, 03 etc.

See this google thread for a method by Max.

http://snipurl.com/1atea


Gord Dibben MS Excel MVP

On Tue, 20 Feb 2007 12:43:00 -0800, Ken wrote:

Excel2003 ... I have a Col containing Dates ... Format = Date 03/14/01

I selected subject Col & added a Filter Switch to it ... intent of Filter
Switch is to Filter Months by selecting "custom" then "begins with" ... then
enter applicable Month (01, 02, 03, 04, etc).

Issue is ... when I do this the Filtered data shows nothing???

Above said ... I have had this issue before ... so guidance would be welcome
...

Thanks ... Kha