title: Excel with XML-Map exports to XML with invalid decimal separator
body: <p>I have created an Excel Sheet, mapped it to an XSD schema and export the data to an XML File. This works fine except the fact, that the decimal values in the XML file have a wrong decimal separator.</p>
  
  <p>I am from Europe and as many people are aware of, different than in the US, here we use the comma as decimal separator. So localization of the OS and Excel perfectly automatically use the comma.</p>
  
  <p>But for example the entered number 7,5 in Excel results in a 7.5 value in the XML. There are no options to influence it. Neither in Excel, not in the export function or the XSD Definition. Since my regional settings should make sure comma is used, the Excel export seems to have a hardcoded conversion.</p>
  
  <p>I use PowerBI to process the XML files and PowerBI expects a comma as decimal separator and here the numbers are totally screwed. The decimal . is ignored and so 1.7 gets interpreted as 75. </p>
  
  <p>I hope this is a covering explanation.</p>
  
  <p><strong>Excel:</strong>
  <a href="https://i.stack.imgur.com/yGhbY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yGhbY.png" alt="enter image description here"></a></p>
  
  <p><strong>XML:</strong>
  <a href="https://i.stack.imgur.com/1jouq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1jouq.png" alt="enter image description here"></a></p>
  
  <p><strong>Power BI:</strong>
  <a href="https://i.stack.imgur.com/e4cWF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/e4cWF.png" alt="enter image description here"></a></p>
  
  <p>A completely similar issue is explained very well in this <a href="https://www.mrexcel.com/forum/excel-questions/517970-format-xml-eksport-excel-2010-a.html" rel="nofollow noreferrer">Excel forum</a>, but not answered. </p>
  
  <p>How can I solve this?</p>