Convert dates stored as text to dates Follow these steps: Select a blank cell and verify that its number format isGeneral. In the blank cell: Enter=DATEVALUE( Click the cell that contains the text-formatted date that you want to convert. Enter) Thank you for your unde...