Excel Format cell

ls

Hello,
with Nav 5.0 SP1 I should insert in Buffer Excel Table a code (0000000000) in a cell, not like a number, but as a code, I could do it?

Thanks
ls

Belias

add a single quote mark at the beginning of the string before exporting

ls

Dou you know if I should give a value to Number Format field in 370 table (it's the only one about format, but my input is a string!)?

Belias

you can evaluate numberformat column with '@' value...
but sometimes is not sufficient, because excel cuts out leading 0s or give strange results.
single quote mark is a 100% working solution

Savatage

you also don't have to do it in the excel buffer.

If your mapping a field from a report (for example)
EnterCell(Row, Column, ''''+Item."Item UPC/EAN Number", FALSE, FALSE, FALSE);

adding the 4 single quotes to the beginning of the field works too. It allows the zeros to stay put.