need help with Filters

[mikehk]

I can see the numbers when I use Filter, but when I search the number in Filter it says no matches!
Please see the attached screenshot. All cell format is Accounting.

[MarvinP]

Hi mike,

I suspect this is a rounding condition. You might have 3920.004 which is displayed as 3920.00. See if that is the case.

[mikehk]

there is no formula in cell. In fact these are amounts for cheque issued.

[marianna.ark]

Could it be that excel needs you to type the "," seperating the thousands?

[mikehk]

already set column to comma style (format with a thousand seperator)

[xlnitwit]

You need to type 3,920 into the filter dialog including the comma.

[mikehk]

hehe...that works

Thanks a lot