filter not working

Stephen Hindes

i created a filter, that searches a column on "Contains". i put in a number by copying a cell and pasting it in. When i apply it comes up with nothing. I checked the format of the column and it is Text/number. Can anyone have an idea what i am doing wrong.

Paul Newcome

Are you able to provide screenshots for reference/context?

Stephen Hindes

1-shot with a PO #

2-shot of the Filter

3-the results

Production Order # is a text/number field

when i use the "one of" it works fine.

also i tried to copy the cell and typing from scratch and still both results are the same, nothing.