Export to Excel Item no. question

SbhatSbhat Member Posts: 301
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

Comments

Sign In or Register to comment.