0% = blank

[broogle]

Is there any format to make the cell equal to blank if the value = 0%.
Thanks

 

[Bob Phillips]

Menu Tools>Options and on the View tab, uncheck the Zero Values box.

 

[Rob van Gelder]

Custom Number Format:

0%;-0%;

 

[Tom Ogilvy]

0%;-0%;;@

format=>Cells, Number tab, put in Custom.

 

[broogle]

Thanks a lot!!!

0%;-0%;;@

format=>Cells, Number tab, put in Custom.