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.
I signed up for the Hortonworks Certified Associate exam last Thursday. Figured if I sign up, I'd have to take the test. And if I tak...
This blog post is in no way an attempt to steal other people's work. It's basically an conglomeration of notes from research I did...
Saw a post today on Twitter, " Microsoft releases CNTK, its open source deep learning toolkit, on GitHub " This is big news. Be...