office-winner

Turn off Error Checking With error checking turned on in Excel, you see an error indicator if you enter a date with a two-digit year into a cell that has text formatting applied to it. If you want, you can turn off this Error Checking feature. Click the File tab. Click Options . In the Excel Options dialog box, click the Formulas category. Under Error checking rules , clear the Cells containing years represented as 2 digits check box. Click OK .

  Excel Error Codes Error Code Description #VALUE! You used the wrong type of data. Maybe your function expects a single value and you submitted a whole range. Or, more commonly, you might have used a function or created a simple arithmetic formula with a cell that contains text instead of numbers. #NAME? Excel can't find the name of the function you used. This error code usually means you misspelled a function's name, although it can indicate you used text without quotation marks or left out the empty parentheses after the function name. #NUM! There's a problem with one of the numbers you're using. For example, this error code appears when a calculation produces a number that's too large or too small for Excel to deal with. #DIV/0 You tried to divide by zero. This error code also appears if you try to divide by a cell that's bla...