Returns or sets the decimal separator character that Microsoft Excel uses when you import a text file into a query table. The default is the system decimal separator character. Read/write String. Use ...
Numeric values exported in Excel are divided by 1000. I think this is because thousand separator is "," in English speaking country and "." in, for example, Italy or France.