Number field turned out as text in Excel, SSRS?

Question

My SSRS reports one of the field is using this expression, where the field is a number field. I want to see blank field is the value is `0`. =IIf(Fields!PERIOD02_VALUE.Value <> 0,Fields!PERIOD02_VALUE.Value ,"") the Excel exported version is having this field considered as text not number. Is there any other way to do this from SSRS side?

Answer 1

If I am understanding the question, it seems as if the problem is Excel is converting your numbers to text when they are placed into the Excel sheet. This answer is going off of that being the issue and my apologies if I did not completely understand the question.

If you have a column of "numbers" that Excel is seeing as text, you can convert that text into numbers using the Value function. I would create a helper column and use =Value(Text) aka =Value(B2) for example, copy it all they way down your dataset that needs to be converted, then copy that converted data and paste over the text that looks as if they are numbers using PasteValues. Your numbers will now be numbers that can be used in calculations.

Hope this helps.