• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

hiding zero from empty cell formatted for a result

R

rdownes

New Member
I am building a spreadsheet but i have zeros and div0 showing up in all of my cells formatted for results. I want to keep them blank until there is actually a result to go into them.


thanks
 
@rdownes

Welcome to the Jungle..


File > Excel Option > Advanced >

Uncheck 'Show a Zero in Cell that have Zero value' (Alt + Z)
 
You must log in or register to reply here.
Back
Top