DataFormatString & export to Excel

[Andy]

Hi all,
 
I am using the GridBoundColumn to display my DateTime data.
And I use the  DataFormatString="{0:MM/dd/yyyy}"  to make time invisible.
However, when export to Excel, it appears (see Image)
I just want to display day only.

<telerik:GridBoundColumn HeaderText="ETA Date" UniqueName="ETA_Date" DataField="ETA_Date" DataFormatString="{0:MM/dd/yyyy}" ReadOnly="true" SortExpression="ETA_Date"  >
     <HeaderStyle Font-Bold="True" Wrap="False" HorizontalAlign="Center"></HeaderStyle>
      <ItemStyle Wrap="False" HorizontalAlign="Center"></ItemStyle>
</telerik:GridBoundColumn>

Thanks.

Andy,

[Princy]

Hello Andy,

You can achieve this by using the mso-number-format style attribute. Check the following help documentation which explains more about this.
Word/Excel export (HTML-based).

Thanks,
Princy.

[Andy]

Princy,

Thanks for your relying.
It works well.

Andy.