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.
Collection Accounts are Removed Based on the Original Delinquency Date. Collection accounts stay on the credit report for seven years from the original delinquency date of the original debt, or the date of the first missed payment after which the account was no longer brought current. You may see both the collection account and the account with your original creditor on the credit report.