Formating number in an Excel Column

rmouza

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.

rsfairbanks

If you are using excel buffer try

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

Any other format get from excel (see format>>cells>>custom)

Miklos_Hollender

I generally use the XML format: that's well-defined, and safe: FORMAT(Item.Inventory,0,9);

rmouza

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