Dowloading to excel zeros converted into commas

[ozcano]

Hello

Report screen shows this:

But after downloading to excel I get commas

How can we prevent this?

Regards, Ozcan

[Chanty4u]

You can try 

Num(yourfield) and then export to excel

[ozcano]

Hello

It is already there, but does not work:

num(sum(CancelQty),'###.###.###.###,##')

Regards

[Anil_Babu_Samineni]

@ozcano Can you perhaps add around Text() to your column and export it? This is more like to understand the situation. 

[ozcano]

Hello

İf I do text(), it brings like that for amounts in Excel:

Should I continue like this or anything else?

NOTE: My separators are like this in the load script:

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 TL;-#.##0,00 TL';

[Anil_Babu_Samineni]

@ozcano This looks OK because your system variable also in the same format. 

[ozcano · Accepted solution]

Hello

I resolved the issue by changing numbering format from Auto to Number.