SSRS 2000 - - currency converted to text with export to Excel

• Tara Ernst-295147

  SSC Enthusiast

  Points: 104

  More actions

  February 21, 2007 at 2:14 pm

  #369608

  Hello.

  When exporting a report to Excel, is it possible to keep the properties around numeric values?  More specifically - when exporting a report into Excel all of the numbers in a currency column are stored as text once placed into Excel with a warning 'Number Stored as Text', which in turn restricts the user from performing any calculations on the cells.  Is there a way to keep them as a currency value?

  Any assistance on this issue would be greatly appreciated!

• February 26, 2007 at 8:00 am

  This was removed by the editor as SPAM

• Kerrie Sorrell

  SSC Eights!

  Points: 921

  More actions

  February 26, 2007 at 9:37 am

  #691812

  In the expression you could do something like CDEC(Fields!expression.value). It turns that field into a Decimal.

  Thanks, Kerrie