I would suggest you don't load the data into a float datatype unless you're sure that's what you want. Best to use a high precision numeric.

In the import wizard, I think you can intervene on the sql which is used for the create table. Otherwise tweak your table manually and then point to it during the import.

make sure your datatype makes sense. It looks like numeric data, but what is with the leading zeroes? Also if you're searching for numerical data, then don't put it in quotes.