format big number to text

[xieyun]

hello everybody!i want to export datatable to excel,but the problem appearence.i want format this number "400101000101150104" as text but i tried some method haven't the result.the excel file aways give me the number:4.00101E+17
now what should i do?thanks all~

[xieyun]

go on,thanks for your help.

hello everybody!i want to export datatable to excel,but the problem appearence.i want format this number "400101000101150104" as text but i tried some method haven't the result.the excel file aways give me the number:4.00101E+17
now what should i do?thanks all~

[Geetha M]

Hi,

I hope your issue has been resolved. Please let me know if you have any other concerns.

Regards,
Geetha

[xieyun]

thanks for your attention,i solved this problem in the end by the way:xlsWorksheet.ImportDataTable(sourceDt, false, 6, 1, 65535, 20, true);
the last parameter tell xlsio to preserve the type of datatable's.
best wish~

[Geetha M]

Hi,

Thank you for the update.

Regards,
Geetha