title: Number field turned out as text in Excel, SSRS
body: <p>In my SSRS reports one of the fields is using this expression, where the field is a number field. I want to see blank field if the value is <code>0</code>.</p>
  
  <pre><code>=IIf(Fields!PERIOD02_VALUE.Value &lt;&gt; 0,Fields!PERIOD02_VALUE.Value ,"")
  </code></pre>
  
  <p>the Excel exported version is having this field considered as text not number.</p>
  
  <p>Is there any other way to do this from SSRS side?</p>