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 understanding and patience NikolinoDE I know I don't know anyt...