[Solved] Add $ sign in Export to EXcel column

[Siva]

Hi
     I want to Add "$" sign in the Exported Excel column .In the Grid am using  gridtemplate column 

Aspx
--------

<

 

telerik:GridTemplateColumn

HeaderText=" Value (USD)" UniqueName=" Value (USD)">

 

<ItemTemplate>

 

<asp:Label ID="lblDollar" Text="$" runat="server"></asp:Label>

 

<asp:Label ID="lblValue"  Text='<%# Eval("Value")%>' runat="server"></asp:Label>

 

</ItemTemplate>

 

</telerik:GridTemplateColumn>
On exporting the radGrid I only got the values in the Excel column not the $ sign. wat i am missing. Thanx in advance..

[Shinu]

Hi,

Try the following code.
C#:

protected void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
    if ((e.FormattedColumn.UniqueName) == "UniqueName")
    {
        e.Cell.Style["mso-number-format"] =@"$0.00";
    }
}

Thanks,
Shinu