Formating number in an Excel Column

rmouzarmouza Member Posts: 52
Hello EveryBody,

I've developped a function to export data from Navision Formular to Excel sheet.
The problem is that when i export Decimal Column, the "Euro Symbol" is shown in Excel (i don't need this).
How to display Decimal data (adjusted to the right) without the "Euro Symbol"?

Thanks.

Comments

  • rsfairbanksrsfairbanks Member Posts: 107
    If you are using excel buffer try

    xlBuffer.NumberFormat := '#,##0;[Red](#,##0);';

    Any other format get from excel (see format>>cells>>custom)
  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    I generally use the XML format: that's well-defined, and safe: FORMAT(Item.Inventory,0,9);
  • rmouzarmouza Member Posts: 52
    thanks everybody,

    i've got this result: x.xx% and x,xx"euro symbol"

    the problem now is how to obtain the same format (in the excel sheet) for both from Navision code.

    So is it possible and how?

    thanks
Sign In or Register to comment.