title: How do I change imported data from decimals to commas in Google Sheets?
body: <p>Using the <code>=IMPORTHTML</code> function, I imported data from a website to google sheets. The page I want to import from is: <a href="https://www.tools4albion.com/refining.php?cat=ore&amp;city=5&amp;quantity=80&amp;skillT4=28&amp;skillT7=0&amp;return=5&amp;tax_sell=6&amp;tax_shop=30&amp;skillT5=17&amp;skillT8=0&amp;tax_order=1.5&amp;skillT6=1" rel="nofollow noreferrer">https://www.tools4albion.com/refining.php?cat=ore&amp;city=5&amp;quantity=80&amp;skillT4=28&amp;skillT7=0&amp;return=5&amp;tax_sell=6&amp;tax_shop=30&amp;skillT5=17&amp;skillT8=0&amp;tax_order=1.5&amp;skillT6=1</a>, however the website uses decimals rather than commas to separate numbers (not to confuse with fractional numbers like "0.2" and so on). When viewed on Google Sheets, it creates 2 problems:</p>
  
  <ol>
  <li>The numbers with triple decimals gets automatically aligned to the left rather than the usual right.</li>
  </ol>
  
  <p><a href="https://i.stack.imgur.com/WK1uG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WK1uG.png" alt="Screenshot of Google Sheets with numbers misaligned to the left"></a></p>
  
  <ol start="2">
  <li><p>It leaves some very important data to indent, which completely changes it's value (the value is supposed to be 545760 but google sheets displays it as 545.##)</p>
  
  <p><a href="https://i.stack.imgur.com/lNd5q.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lNd5q.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/pARR1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pARR1.png" alt="enter image description here"></a></p></li>
  <li><p>No calculations, functions or arithmetic can be performed on triple-decimal data. Even those with decimal are treated as fractional numbers rather than integers.</p>
  
  <p><a href="https://i.stack.imgur.com/sLxtz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sLxtz.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/OxYa5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OxYa5.png" alt="enter image description here"></a></p></li>
  </ol>
  
  <p>For those of you who want to try it, I used the formula:</p>
  
  <pre><code>=IMPORTHTML("https://www.tools4albion.com/refining.php?cat=ore&amp;city=5&amp;quantity=80&amp;skillT4=28&amp;skillT7=0&amp;return=5&amp;tax_sell=6&amp;tax_shop=30&amp;skillT5=17&amp;skillT8=0&amp;tax_order=1.5&amp;skillT6=1","table",5)
  </code></pre>
  
  <p>Any ideas on how I can fix this issue? If there is no such solution that exist on Google Sheets. I have no problem doing this with Microsoft Excel. Answers from either software is fine with me.</p>