Turn off Error Checking

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.
  1. Click the File tab.
  2. Click Options.
  3. In the Excel Options dialog box, click the Formulas category.
  4. Under Error checking rules, clear the Cells containing years represented as 2 digits check box.
  5. Click OK.

Comments

Popular posts from this blog

Writing Systems Of The World

International Phonetic Alphabet

GRBL Feed Rate