Thanks for the Reply Roger..... I created a new test file and was able to
recreate the issue. what format are you using. It seems to me that the
cells with double entries are formatted as text and the one with one entry
are formatted as numbers. I have tried to play around with different formats
but I have not had much success.

"Roger Govier" wrote:

Hi Marylin

I cannot reproduce your problem.
If I type Contains, then the number, it picks up the values from both single
entry cells, and those with 2 numbers separated by an Alt+Enter to force the
carriage return within the cell.

--
Regards
Roger Govier

"Marilyn" wrote in message
...
Hello,

I have an excel table which I often filter. The column that I filter by
has
numbers and some of the numbers have a carriage which means some cells
have
two lines instead of one and some cells just have one line.

When I perform a Custom filter I choose Custom from the drop down list and
select Contains and type desired number. The problem is that the Contains
criteria only picks up the cells with 2 lines and omits the cells with 1
line
that matches the filter. If I choose Equals then the Equals criteria only
picks up the cells with 1 line and omits the cells with 2 lines.

Example: The numbers with the quotes share one cell.
"6.2
6.7"
"3.4
5.3"
5.2
"1.1
3.3"
3.4

any ideas what can be done in this case?