Forum Discussion
Filter function returning a "0" (Zero) when the source cell is blank or null
Hello all, I'm hoping that this isn't too obvious but I've noticed this situation several times and have had to work around it. I have a situation where the output of a FILTER function is cr...
TheOldPuterMan The simple fix for me was unchecking the 'Show a zero in cells that have zero value'
Located here: File>Options>Advanced>Display options for this worksheet
Omg thank you so much. This is way simpler, and everything else converted the date to # format.
On Mac it can be switched in the Properties (CMD-',') under "View -> Show in Workbook -> Zero Values"
- This is the real solution
