While exporting the data to excel in NAV 2009, i faced a different problem.
I have a value for "Vendor Bank Acc. No." = 00027928.
But while exporting to excel the leading zero's will automatically deleted and displayed as 27928.(Its default excel functionality).
And the workaround for above problem is : put a ' before your field so Excel treats it as text.
add the '''' + before the field (4 single quotes).
I have a value for "Vendor Bank Acc. No." = 00027928.
But while exporting to excel the leading zero's will automatically deleted and displayed as 27928.(Its default excel functionality).
And the workaround for above problem is : put a ' before your field so Excel treats it as text.
EnterCell(Row, Column, '''' + "Vendor Bank Acc. No.", FALSE, FALSE, FALSE); add the '''' + before the field (4 single quotes).
