Filter suddenly not working

Hi All,

I have an issue of a filter not working that previously worked fine.

The filter looks for cells in a column formatted for text/numbers.

Here's an example of the data in the column:

NLOND_3104-1

NLOND_3709-2

-2

-1

-2

NLOND_5612-1

The filter looks for data that contain -1 and another filter looks for data that contains -2.

However it now only reports data with the text in front of it. The -1 and -2's on their own cannot be found. Only the NLOND##### is reported.

Has anyone got any ideas?

Thanks,

Mark