change date format

[Jokar64]

I currently download a report into Excel from a database and when I open-up
the file the date has the time after it, and I am trying to reformat the date
to only include the date and not the time.

 

[Bob I]

is it really a date, or is it text that just looks like a date?