To display zero 0 values in cells. Vlookup to return blank or specific value instead of 0 or NA error value in Excel Kutools for Excel s Replace 0 or NA with Blank or a Specific Value utility helps. And in the midst of these options go ahead and find the box that says Show a zero in cells that.
Under Display options for this worksheet select a worksheet and then do one of the following.
Select the range of continuous cells along with blank cells in the active worksheet. This method can help you to format the summation 0 as blank cell please do as this. Enter NA in the cell thats referenced as the divisor in the formula which will change the formula result to NA to indicate the divisor value isnt available. Under Display options for this worksheet select a worksheet and then do one of the following.