Ran into a bug when exporting SQL Server Reporting Services to Excel. The field which contained a Currency in SSRS exported to Excel as a Text.
So one option was to multiply the SSRS formula by 1.000
By doing this, the field successfully converts to a number in Excel. However, there is no currency symbol $.
So in order to keep the Currency symbol $, you have to set the property called "Format" to "C":
And this solved the problem. Hope that helps.