When you import data from Excel using wizard, the column with Date will appear in this format

yyyy-mm-dd hh:nn:ss.mss

so you can now select the imported table with formatting date convert(nvarchar, date_column, 105)

The script will look like this:

SELECT your_columns, CONVERT(NVARCHAR, date_column, 105) AS your_format

FROM imported_table