Export to Excel Item no. question

Sbhat

I have a client who have their Item no. as 00045648333443 and when I create a report to send it to excel it drops the leading 0's and just shows as 84453555 or sometimes shows as 8E+2E0 something like that. I am just using Excelbuf.Addcolum(item."No.",false,false)
Is there any way you can format it such that it shows 00045648333443 in Excel keeping the leading 0's.

Thanks

mr_ash

Hi,
This is problem with excell cell format - that should be set as "Text".
Excel buffer table in NAV 5 and 2009 (don't remember earlier versions) has a field named "Number format", and you should use @ sign for this field.

The @ (at) sign determine text format for the cell, for example:

ExcelBuffer.AddColumn(FORMAT(Value),FALSE,'',FALSE,FALSE,FALSE,'@');

postsaurav

Hi,

I hope this should help you.
http://saurav-nav.blogspot.in/2012/06/nav-report-export-to-excel-number-as.html

Let me know if you have any issues.