Forum Discussion
Filter not working (monetary values)
Hi, y'all! Tis weird, but the most basic function of Excel (filtering values) is not working as it should. I'm building a table with a colum for costs, and the other columns for descriptions, locati...
I am filtering on a value of 400 formatted as currency : R400.00. If I use the 'Equals' auto filter set to 400 it does not find the values. If I use the 'Between' 400 and 400 it finds it ! If I use the Equals again but set the value to R400.00 it finds it ? This must be an Excel thing.
