Hi Wendy

Have you tried using a standard Autofilter and using a custom filter
from the dropdown arrow of the relevant column of "Does not equal" 0?

Richard


WendyMc wrote:
I would be grateful for any help - I have a spreadsheet with 8000 rows, I
would like to be able to hide the rows that contain a 0.00 - and entering the
0 in the advanced filter worked fine - however I would also like to be able
to see the data that is a negative ie -109.00 Is there some way I can enter
Not 0.00 or does not equal 0.00 Does any of this work in advanced filters??
Many thanks for any advice

Wendy