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...
Data becomes information. Information adds value if used properly to align business practices, streamline processes with net result of incr...
Data is the new oil. Sort of a good analogy. Except new oil is constantly required. And there is only so many oil wells on the planet. A...
What do you want to do when you grow up. For some of us, we still haven't decided. After close to 50 years. Chances are, if you chos...