Today, while changing a report in SQL Server Reporting Services I noticed that my report when exported to excel was showing the dreaded “Number stored as text.” When a value was 0, I was replacing with a blank string. By changing it to return Nothing. I was able to get rid of the dreaded Number […]