Convert an error to zero and use a format to hide the value. You can hide error values by converting them to a number such as 0, and then applying a conditional format that hides the value. Create an example error. Open a blank workbook, or create a new worksheet.Enter 3 in cell B1, enter 0 in cell C1, and in cell A1, enter the formula =B1/C1. The #DIV/0! error appears in cell A1. Select A1, and press F2 to edit the formula. After the equal sign (=), type IFERROR followed by an opening parenthesis.ou can hide error values by converting them to a number such as 0, and then applying a conditional format that hides the value. Create an example error. Open a blank workbook, or create a new worksheet.
- Bankruptcies that, from the date of adjudication, (means decision) antedate (means predate) the report by more than 10 years. - Collection accounts and charge offs remain for 7 years from first serious delinquency or charge off date. - Paying an old debt does NOT reset the clock on reporting for another 7 years.
According to Experian, hereâs how long six common negative items stay on your report if you arenât able to remove them: Collection accounts: seven years after the first delinquency. Late payments: seven years from the first late payment, even if youâve caught up and the account is current or closed.