Filtering on Date Only

I have a work sheet that has a column with dates and text in it, what i would like to do is filter so that only field that have dates are shown.

Thanks,


Graeme

Hi Graeme,

That was a mission - the wildcard characters didn't work on dates. However, setup the Custom Filter like this:

Is greater than 01/01/1901 or is less than 31/12/2099.

HTH,


Roly