Text<\/li>\n<\/ol>\n\n\n\nWe are going to use the following format:<\/p>\n\n\n\n
#;\"-\"#;<\/pre>\n\n\n\nIt will keep positive numbers as positive, and negative numbers as negative, but avoid zeros and text. In practice, this means that zeros will be displayed as blanks.<\/p>\n\n\n\n <\/figure>\n\n\n\nYou can easily modify this format to display dashes (-) instead of zeros.<\/p>\n\n\n\n
#;\"-\"#;-<\/pre>\n\n\n\nThis will give the following result.<\/p>\n\n\n\n <\/figure>\n\n\n\nThe other way to display blanks or dashes, instead of zeros, is by using the IF function.<\/p>\n\n\n\n
So far we used this formula for cell A7<\/strong>.<\/p>\n\n\n\n=SUM(A1:A5)<\/pre>\n\n\n\nLet\u2019s modify this cell, so it\u2019s going to display blank if the result is 0.<\/p>\n\n\n\n
=IF(SUM(A1:A5)=0,\"\",SUM(A1:A5))<\/pre>\n\n\n\nModify the remaining cells. It will give you the following result.<\/p>\n\n\n\n <\/figure>\n\n\n\nOf course, the slight modification will result in dashes instead of blanks.<\/p>\n\n\n\n
=IF(SUM(A1:A5)=0,\"-\",SUM(A1:A5))<\/pre>\n\n\n\nHide all zeros inside a worksheet<\/h2>\n\n\n\n So far, we replaced zeros in the selected range. If you want to hide zeros for the entire worksheet you can do it inside Excel options.<\/p>\n\n\n\n
Go to File >> Options<\/strong>. Inside the Excel Options<\/strong> window click Advanced<\/strong> and find an area called Display options for this worksheet<\/strong> and find a position called Show a zero in cells that have zero value<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nNow, you can see that not only the cells that are in row 7 are blank, but also those inside the table. These cells are treated as zeros and displayed as blanks.<\/p>\n\n\n\n <\/figure>\n","protected":false},"excerpt":{"rendered":"When you work in Excel, there are situations when you want to either show zero in some cases or hide zero in others….<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Display or Hide Zero Values in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n