View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

In the AutoFilter dropdown for that column, select Custom
In the first dropdown, choose 'greater than or equal to'
In the text box, type: a
Click OK

Lisa wrote:
I have a list in a column, including various comments and dates in 31/01/05
format.
How can I apply a filter so I see everything EXCEPT the dates?

i.e. if i go to <custom filter
<does not equal
<Date...but that that obviously doesn't work
Any suggestions?
Thanks
Lisa



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html