format big number to text

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~


4 Replies

XI xieyun September 5, 2008 01:35 AM UTC

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~



GM Geetha M Syncfusion Team September 9, 2008 06:33 AM UTC

Hi,

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

Regards,
Geetha



XI xieyun September 9, 2008 01:00 PM UTC

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~



GM Geetha M Syncfusion Team September 10, 2008 04:03 AM UTC

Hi,

Thank you for the update.

Regards,
Geetha


Loader.
Up arrow icon