Access VBA decimal seperator point istead of comma in XML Download -

we run simple ms access database can import data either xls or xml file (webservice).

the problem numbers in xls file have format: 123.456,78 , in xml file: 123,456.78.

since in germany need the first format. there simple method in vba change format type when using xmldoc function?