title: Excel: mapped XML data and the "number stored as text" error
body: <p>A colleague of mine has an XML document which she opens in Excel 2007, using "Get External Data / From XML Data Import".</p>
  
  <p>Excel maps the XML to columns automatically. However, some elements store numerical data, which Excel refuses to treat as a number:</p>
  
  <pre><code>&lt;SOME_NUMBER&gt;68.12&lt;/SOME_NUMBER&gt;
  </code></pre>
  
  <p>Instead, the cell shows the "number stored as text" error.</p>
  
  <p>Currently no XML Schema is attached to the document, and I would want to avoid creating one, if possible. What other options are there?</p>
  
  <p>P.S.: Trying different regional settings was unsuccessful. Data always seems to be viewed as text.</p>