title: ExpressQuantumGrid Excel export of FMTBCD fields without currency symbol and format ",0.00"
body: <p>According to this DevExpress Knowledge Base entry for the ExpressQuantumGrid, <a href="http://www.devexpress.com/Support/Center/p/B91868.aspx?searchtext=excel+fmtbcd" rel="nofollow">Excel-Exports from a cxGrid formats FMTBCD-Fields with a currency-Symbol</a> it is necessary to use calculated fields of type TFloatField to export FMTBCD fields wihtout the currency symbol to Excel. The example code in the Knowledge Base works as expected.</p>
  
  <p>However I also need to add a precision of two decimal digits in the exported file for the calculated field. </p>
  
  <ul>
  <li><p>I tried to use Properties=CalcEdit with DisplayFormat=",0.00" but the export does not use the DisplayFormat of the grid column</p></li>
  <li><p>I tried to set the DisplayFormat of the calculated field, but the export does not use the DisplayFormat of the data field</p></li>
  </ul>
  
  <p>Using version 6.54. (I will also open a support case).</p>