Hi,
I've radGrid in which I display couple of date columns. I format the date using DataFormatString property. It displays good in grid as I want. But when downloaded to excel the values don't make any sense to me.
<
CommandItemSettings
ShowExportToExcelButton
=
"true"
ShowAddNewRecordButton
=
"false"
ShowRefreshButton
=
"false"
/>
<
telerik:GridBoundColumn
DataField
=
"LiquidationDate"
UniqueName
=
"LiquidationDate"
HeaderText
=
"Liquidation Date"
ItemStyle-HorizontalAlign
=
"Center"
DataFormatString
=
"{0:d}"
/>
Attached images to show how they are displayed in grid vs excel. Please help.