if you just want all zeros to NOT be displayed
there is an option in excel to do that

goto options
Advanced

look for

Show a Zero in cells that have a zero value

and uncheck

that will stop zeros being displayed