I checked this out using your method, as well as creating a linked server to the Excel file.

No matter what you do with the data, even using CAST or CONVERT, Excel does not recognize the numbers as numeric data.

You might have to add another step in which you run some VBA code in Excel

that re-formats the columns.