I work in a large Microsoft SQL Server data warehouse that unfortunately uses the Money datatype in many places. For years I have been exporting data to excel and sending off to whoever. Recently though, since I upgraded to TDP 4.0.0.624, when I quick export a dataset to an excel file, the money datatype columns are stored as text. BUT, if I do a quick export to an excel instance, the money columns are stored as numbers and it works fine. So this issue only occurs when exporting straight to a file.
If it makes any difference, we are on office 2007.