title: Reporting Services Format as number
body: <p>I'm trying to format a column in reporting services to display a number with thousand separator and with commas. The expression I'm using is the following:</p>
  
  <p>=Format(Fields!Price.Value, "#,##0.00")</p>
  
  <p>It works great. Also if I use the expression:</p>
  
  <p>=FormatNumber(Fields!Price.Value, 2, true, false, true)</p>
  
  <p>works great too. The PROBLEM is when converting to excel. The column displays in excel as expected but the format of the cell is General instead of number with thousand separator. As a result users cannot apply formulas to the columns due to is treated as string (General formatting). I know I can convert in excel the column to Number format but I'd like that when converting to excel via reporting services the column just appears in number format. </p>
  
  <p>Is it possible? Searching in google doesn't give me any clues.</p>
  
  <p>Thanks in advance</p>