I'm using the sql server data export wizard to create excel files. When I use an Excel 97-2003 destination it works fine. But when I use an Excel 2007 destination then all numbers are formatted as text. (With the little green triangle in the upper left corner.)
Dates and text are formatted properly.
In the Edit Mappings screen, i've tied using decimal, long, currency, varchar, single, and double but all end up as text.
Any help would be greatly appreciated.