Why time format of some rows in excel are different from others

[york]

Hi,
I try to export radgrid to excel with RadGrid1.MasterTableView.ExportToExcel(). I am using MS office 2010.There is a weird thing in excel file. The time format of some rows are AM/PM and others are not (24 hours). In the radgrid, all rows are AM/PM format and are displayed correctly. But why in the exported excel file, some rows are not AM/PM? Thanks.

[Shinu]

Hello York,

Try setting the DataFormatString as shown below.
aspx:

<telerik:GridBoundColumn  DataFormatString="{0:yyyy-MM-dd hh:mm tt}" UniqueName="BirthDate" HeaderText="BirthDate" DataField="BirthDate">
</telerik:GridBoundColumn>

Thanks,
Shinu.

[york]

Hi Shinu,

The DataFormatString is correct. But the strange thing I just notice is that, in the exported excel file, date from 1 to 12 is of format of AM/PM, while date from 13 to 30/31 is of format of 24 hours. Can you explain it? Thanks.

York

[Shinu]

Hello York,

I cannot reproduce the issue at my end. The above code worked as expected in my end. Also please try setting mso-number format as explained in this documentation.
Word/Excel export (HTML-based).

-Shinu.

[york]

Thanks a lot, Shinu, mso-number-format is working. What is the hell of mso-number-format?