How do I do a NOT search in a number field?
As long as it is not a number field where the value is calculated, like the Mol. Wt. field, you should be able to use the <> operators. For example, you would type in the number field: <>123 to prevent any values of 123 being returned in the results.