format big number to text

Thread ID:	Created:	Updated:	Platform:	Replies:
76386	Sep 4,2008 11:13 AM UTC	Sep 10,2008 04:03 AM UTC	WinForms	4

Subscribe to this post

Tags: XlsIO

xieyun

Asked On September 4, 2008 11:13 AM UTC

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~

Reply | Reply with quote

xieyun

Replied On 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~

Reply | Reply with quote

Geetha M [Syncfusion]

Replied On 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

Reply | Reply with quote

xieyun

Replied On 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~

Reply | Reply with quote

Geetha M [Syncfusion]

Replied On September 10, 2008 04:03 AM UTC

Hi,

Thank you for the update.

Regards,
Geetha

Reply | Reply with quote

CONTACT US

format big number to text

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US