Text Format in Export to Excel

navuser1

Dear All,

Using Excel Automation I'm exporting data into Excel,But my data comes 10001 instead of 0000010001.
What to do ?

Luc_VanDyck

Export your data as '0000010001 (with a apostrophe in front of the field).

navuser1

Luc Van Dyck wrote:

Export your data as '0000010001 (with a apostrophe in front of the field).

My C/AL code is :
XlWrkSht.Range(A).Value := Item."No.";

Luc_VanDyck

Thx for sharing.

crisnicolas

If you use the Excel Buffer table, you could assign '@' to FormatNumber field.
This will export your data with format Text instead of the default General.