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.
Active positive information can remain indefinitely (if an account is closed that has been positive, then it will typically remain on your report for 10 years after the date the account is closed). Collection Accounts: A collection account remains for 7 years from the initial missed payment that led to the collection. Public Records: Chapter 7, 11 and 12 bankruptcies remain for 10 years from the date filed. Completed Chapter 13 bankruptcies remain for 7 years from the date paid, and 10 years if not completed.
Accounts to a debt collector are reported to the credit bureaus as being charged off or sold to a debt buyer. The debt collector then reports the debt as a new account that is added to your credit history. The original account and the collection account can stay on your credit record for up to seven years, at which time both are removed. The Nolo website says you may be able to get collections removed early as part of a payment agreement with the debt collector, or the original creditor if the debt hasn't been sold.