Depends on what columns you changed the formatting on. ;)\n\n\nlol ok so anything in column X that does not have a value is coming back as '0'. i had the hide option engaged. can i remove the zero and not hide it? i'm having trouble finding a way to do this with a formula.