How I change excel date format with Telerik Radgrid?

[Mascherano]

I using Radgrid excel export. I have date column and I need change format with excel.

Protected Sub RadGrid1_ExcelExportCellFormatting(ByVal sender As Object, ByVal e As ExcelExportCellFormattingEventArgs)

        If ((e.FormattedColumn.UniqueName) = "date") Then

            e.Cell.Style("mso-number-format") = "m\/d\/yy\"
        End If
    End Sub

and I used OnExcelExportCellFormatting in aspx file. My grid show true but my date column show like this in excel;

"4 january 2013 Friday 00:00:00"  

How I change date format for excel?

[Maria Ilieva]

Hi,

Try using the code below:

Protected Sub RadGrid1_ExportCellFormatting(sender As Object, e As ExportCellFormattingEventArgs)
    If (e.FormattedColumn.UniqueName) = "Uniquename" Then
        e.Cell.Style("mso-number-format") = "m.d.yy"
    End If
End Sub

Regards,
Maria Ilieva
Telerik