Leading zero in export to excel

(0) Share

Report

Posted on by NavTech

2,390

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Hello,

Put CellType as Text or @ while in export code.

Was this reply helpful? Yes No
Suggested answer

Alex A 2,913 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Check the format function

Was this reply helpful? Yes No
Andrea Antoniazzi 285 on at

Like (1)

Report

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'

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Tharanga Chandrasekara 23,118 on at

Like (0)

Report

Were we able to help you to resolve the issue?

Was this reply helpful? Yes No