How to get rid of 'Number stored as text' after rendering report in Excel from SSRS

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!
LVL 5
catherinelouiseAsked:
Who is Participating?
 
natlozConnect With a Mentor Commented:
No, I am talking about right clicking on the cell in the "Report" that holds the number and going to the properties and in the "Format" section typing in 00.0%
0
 
natlozCommented:
In the format for the cell, what if you type in 0.00%
0
 
catherinelouiseAuthor Commented:
Hello, I've just reread my question and I don't think I worded it very well - so the matrix is in a SQL Server Reporting Services report, and it's when I render into excel that I have this problem.

I think by your question you mean is it resolved by amending the format of the excel cell?  This would not really be an option as the report will be auto-run and rendered into Excel for distribution to clients, so this problem has to be resolved in SSRS and not in Excel.
0
 
catherinelouiseAuthor Commented:
Heh well I beg your pardon.  I have done this and it has done the trick.  I always assumed this way of formatting the cell was just doing the same thing behind the scenes and never used it - how does this way differ?

Thank you very much anyway!
0
 
natlozCommented:
I think the excel renderer does not always interpret the data to be of a specific datatype unless it is defined in the report, it just assumes that it could be anything, therefore a string is what it uses.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.