Dates doesn't show up right in when downloaded to excel

[Tess]

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. 

[Tess]

Here is the Grid image. I've attached both Excel images in my post..

[Attila Antal]

Hi Tess,

Try using the following format "{0:MM/dd/yyyy}" and see if that works for you.

<telerik:GridBoundColumn DataField="LiquidationDate" UniqueName="LiquidationDate" HeaderText="Liquidation Date" ItemStyle-HorizontalAlign="Center" DataFormatString="{0:MM/dd/yyyy}" />

You can test the basic sample I've attached.

Kind Regards,
Attila Antal
Progress Telerik

[Tess]

Thank you Attila Antal. It worked.

[Attila Antal]

Hi Tess,

I am glad the solution helped.

Good luck with your project!

Kind Regards,
Attila Antal
Progress Telerik