Report format as number

Question

I am trying to format a column in Reporting Services to display a number with thousands separator and commas. The expression I use is as follows:

= Format (fields! Price.Value, "#, ## 0.00")

It works great. Also, if I use the expression:

= FormatNumber (Fields! Price.Value, 2, true, false, true)

works great. PROBLEM is a conversion to excel. The column is displayed in excel as expected, but the cell format is General instead of the thousands separator number. As a result, users cannot apply formulas to columns because they are treated as a string (general formatting). I know that I can convert an excel column to Number format, but I would like to convert the column to numeric format when converting to excel through Reporting Services.

Is it possible? A google search does not give me any hints.

Thank you in advance

Answer 1

The problem is that Format returns a string, so it is converted to Excel.

To achieve what you want, just format the element using the Format property. Click on a cell, open the properties window and update the Format property as #,##0.00

Better yet, make your application international, update the report's Language property =User!Language , and then use N2 as the format property for the cell.