[Solved] ExportToExcel in radgrid convert varchar fields to numeric

[Raghavan Subramanian]

Hi,

I am having problem when exporting radgrid to excel, the varchar fields in radgrid converted to numeric in excel.

For example, '00089' in radgrid in converted to '89' in excel.

Please give any suggestions to fix this.

Thanks in advance.

Regards,
Rags

[Daniel]

Hello Raghavan,

You can avoid the unwanted behavior either by inserting   tags or setting the proper number format on ExcelExportCellFormatting event:
http://www.telerik.com/community/forums/aspnet-ajax/grid/202142-export-to-excel-problem.aspx
http://www.telerik.com/community/forums/aspnet-ajax/grid/grid-export-to-excel-how-to-format-cells-as-text.aspx
mso-number-format

Regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.