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.
How long you should hang on to records; IF you â¦ THEN the period is â¦ File a return and the next 3 situations below do not apply to you: 3 years: Do not report income that you should and it is more than 25% of the gross income shown on your return: 6 years: File a fraudulent return: No limit: Do not file a return: No limit