Export to excel data formatting problem

[Peny]

Hello,

I have a telerik:radgrid which contains the following column
<telerik:GridBoundColumn DataField="LITIGATE_PERSON_CIF" DataType="System.String"
                    HeaderText="CIF Καθού" UniqueName="LITIGATE_PERSON_CIF" DataFormatString="{0}">
                    <HeaderStyle Width="70px" />
                </telerik:GridBoundColumn>

The type of LITIGATE_PERSON_CIF column in DB is varchar(50). An example of data at this column is "9999940374268002".

When i export to excel this grid, i get the value 9999940374268000 at this field.

Should I use another format?

I thing that somehow it rounds the data. How could I avoid that?

Regards,
Peny

[Daniel]

Hi Peny,

I made a simple demo for you. Give it a try and let me know if you need further assistance.
For more information see this link:
Word/Excel export (HTML-based)

Best regards,
Daniel
the Telerik team