Change part of date format

is it seen as a date in the cell , if so , then you should be able to change format to just the date
or if text , you can use a formula in another column BUT not in the same column without VBA
=Left(cell, 10)
should extract just the date
=DATEVALUE(LEFT(A1,10))
then format the cell to how you want to display the date

then you could copy and paste value back to the original column