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.
It could fall off your report after seven years and then reappear as a public record judgment. Suppose you live in a state where the statute of limitations is longer than seven years. Your medical collections account could come off your credit report after seven years. Then the creditor sues you in court and wins.
Most information (good and bad) will stay on your credit report for seven years. However, some financial disasters (divorce, bankruptcy) can stay for as long as ten years. The â¦ silver lining to this is that, the older the negative information is, the less influence it has on the overall report. The seven year statute of limitations on information listed on your credit report figures from the date of last activity. 2  According to the FCR Act Section 605 a debt can remain on a credit report for 7 years and 180 days after the delinquency that caused the account to go bad.