Export Excel with currency format

[Fabio]

Hello,
I have a column in currency format and in the Grid presentation it shows right, for example: 200.00, but when exporting to excel it shows 200. What can I do to solve this problem?

[Mukesh]

Hello Fabio,

Please use below GRID event:

protected void RadGrid1_ExportCellFormatting(object sender, Telerik.Web.UI.ExportCellFormattingEventArgs e)
{
        if (e.FormattedColumn.ColumnType.IndexOf(GridCurrencyColumnName) > -1)
        {
            e.Cell.Style["mso-number-format"] = @"$0.00\;($0.00)"; // Appy your currency format here
        }
       // OR
        if (e.FormattedColumn.UniqueName == "GridCurrencyColumnName")
        {
           e.Cell.Style["mso-number-format"] = @"$0.00\;($0.00)";
        }
}

Thanks,

Mukesh Prajapati

[Had]

You can declare the format directly from the radgrid table datacolumn

<telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="BilledAmt" DataType="System.Decimal" NumericType="Currency" HeaderText="BilledAmt">

 

OR  another way

can also try in ItemDataBound, you can declare the format

if (e.Item is GridDataItem)
 {  
                GridDataItem sampleTable = (GridDataItem)e.Item;
            //the format here refer to above format.
}