Leading zero in export to excel

(0) Share

Report

Posted on by NavTech

2,382

I am not getting leading zero while exporting data to excel using export to excel code . I have tried adding '''' with data but a character ' comes at the beginning.

*This post is locked for comments

All responses (7)

Answers (0)

TharangaC 23,116 on at

Like (0)

Report

RE: Leading zero in export to excel

Were we able to help you to resolve the issue?
Suggested answer

TharangaC 23,116 on at

Like (0)

Report

RE: Leading zero in export to excel

You need to add four single quotes ('''') for the field which you want excel to format as text not as integer.

Check below blog from Saurav : http://saurav-nav.blogspot.co.nz/2012/06/nav-report-export-to-excel-number-as.html
Andrea Antoniazzi 285 on at

Like (1)

Report

RE: Leading zero in export to excel

Hi NavTech,

if you are using the Excel Buffer you can insert '@' in the NumberFormat field. For the decimal values you can insert '#,##0.00'
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Leading zero in export to excel

Check the format function
Suggested answer

Alex A 2,348 on at

Like (0)

Report

RE: Leading zero in export to excel

Hello, you need to highlight the columns in Excel and change the data type /number format. Set a Number format for numerical values, and set a Text format for all alphanumeric characters.
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: Leading zero in export to excel

Hello,

Put CellType as Text or @ while in export code.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Leading zero in export to excel

hi,

did you also used FORMAT(Number) i mean string to export := ''''+FORMAT(YourData)

using the right syntax msdn.microsoft.com/.../dd301367(v=nav.80).aspx