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.
But if these are collection accounts they should not be on your credit report after 8 years. Collection accounts may only be reported for seven years plus 180 days from the date you first fell behind with the original creditor, paid or unpaid. I went through a divorce 12 years ago and she assumed some of the debt.