>I don't if know this will help
>I created a spreadsheet with a column that looked like this 5.12345678
>I used the SQL Server import wizard and the wizard converted the data OK. It made the column a float type.
Did you format the Excel cell as Currency?