Excel Format cell

ls
ls Member Posts: 33
edited 2008-11-19 in NAV/Navision Classic Client
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

Comments

  • Belias
    Belias Member Posts: 2,998
    add a single quote mark at the beginning of the string before exporting :mrgreen:
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • ls
    ls Member Posts: 33
    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
    Belias Member Posts: 2,998
    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
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Savatage
    Savatage Member Posts: 7,142
    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.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org

Categories