How to Hide Zero Values in a Worksheet (Excel 2010)
There are times when zero is a valid data but you don’t want to display the zero in your worksheet. You can change the setting so the zeros are not displayed. After formatting the cells will be blank instead of displaying a zero.