Contains works with embedded - as text. For numerical -, use Less than 0
--
Gary''s Student - gsnu200837


"S. H. Drew" wrote:

I have a list of items and some of them contain the minus symbol (-). I want
to use auto filter to find only those items that contain the minus sign. But
when I select "contains", equals, and then type the minus sign in the
criteria field, it returns no values. How can I get this filter to work?