Step 2:In the Excel Options window, navigate to theFormulastab. Under the Error Checking section, ensure thatEnable background error checkingis checked. Also, check the option forCells containing years represented as 2 digitsunder Error checking rules. Convert Text to Date Using the Text to Colu...