How to get rid of 'Number stored as text' after rendering report in Excel from SSRS
Posted on 2008-10-15
I'm rendering a matrix into Excel and have found that whenever I use the Format function on a cell I then get 'Number Stored as Text' message in Excel - it's the green triangles everywhere that make it look really ugly.
I want to use Format as I am carrying out a division of one value by another in this cell and would like to, at a minimum, display the value to 2 decimal places, or ideally as a nice percentage.
Without Format it renders fine. Using FormatPercent, or Format to P2, N2 etc, I get the message.
Any ways to deal with this would be greatly appreciated!