Learn how to hide error values and error indicators in a cell.br br By converting error values to a number (such as 0) or a descriptive text, and after that using a conditional format to hide the value, you can conceal error values. All to make it look professional and polished.br br Here are the steps for more dynamic approach.br A) Hide Error Valuesbr 1) Select the cellbr 2) Enter formulabr =IFERROR(B2C2,"No Qty")br 3) Apply to all cellsbr br B) Apply Conditional Formatbr 1) Select the cellbr 2) Home -- Conditional Formatingbr 3) Highlight Cells Rules -- Text that Contains...br 4) Enter "Qty"br 5) OKbr 6) Apply to all cellsbr br Here are the steps for a static text approach.