Suppose you want to hide zero values in selected range in excel.
1. On the Home tab, click the Dialog Box Launcher next to Number. (See image below)
2. In the Format Cells box, Select Number tab. Under Number tab, click Custom.
3. In the Type box, enter 0;-0;;@
4. Press OK button
It’s Your Turn!
If you want me to keep writing this site, please post your feedback in the comment box below. While I love having friends who agree, I only learn from those who don't. To hire me for services, you may contact me at firstname.lastname@example.org