I have Excel 2010. My spreadsheet has a filtered table of values. The cells are formatted to show no decimal places. For example, as I expect, a cell with the value 0.01 displays 0. When, I filter a column to exclude cells with a value of 0, the row with the value .01 is also excluded. How can I get around this without formatting the cell to 2 decimal places? Thank you in advance for any suggestions.