You might be able to modify the format from excel wizard. Right click on the column name and change the format to Character

And you might get something like this to your import script
Column Numeric Format(Index(0), Column Name(Date), Datatype("Character"))
-Jarmo