title: Excel Export not accepting thousands separator
body: <p>I have this build up HTML table that I want to convert into Excel spreadsheet but it happens to show the amount thousands separator and the 2 decimal as the PHP function number_format specifies. in short like for 100.00 in Excel I am having 100 </p>
  
  <pre><code>$OutputExcel = "
        &lt;h3 align='center'&gt;$COMPANYNAME&lt;/h3&gt;
        &lt;table class='tblNemoList' border='0' cellpadding='2' cellspacing='0' width='100%' style='-fs-table-paginate: paginate;'&gt; 
           &lt;caption align='left'&gt;&lt;b&gt;Detailed Horse Charges&lt;/b&gt;&lt;/caption&gt;
           &lt;thead&gt;
              &lt;tr&gt;
                 &lt;th align='left'&gt;#&lt;/th&gt;
                 &lt;th align='left'&gt;No&lt;/th&gt;
                 &lt;th align='left'&gt;Horse Name&lt;/th&gt;
                 &lt;th align='left'&gt;Description&lt;/th&gt;
                 &lt;th align='left'&gt;Date&lt;/th&gt;
                 &lt;th align='left'&gt;Amount&lt;/th&gt;
              &lt;/tr&gt;
           &lt;/thead&gt;
     ";
     $i = 0;
     while($row = $xdb-&gt;fetch_object($rowHorseCharges))
     {
        //ini
        $i++;
  
        $OutputPDF .= "
           &lt;tr &gt;
              &lt;td&gt;$i&lt;/td&gt;
              &lt;td&gt;".$row-&gt;No."&lt;/td&gt;
              &lt;td&gt;".$row-&gt;strHorse."&lt;/td&gt;
              &lt;td&gt;".$row-&gt;Description."&lt;/td&gt;
              &lt;td&gt;".$row-&gt;Date."&lt;/td&gt;
              &lt;td align='right'&gt;".number_format($row-&gt;Amount,2,'.',',')."&lt;/td&gt;
           &lt;/tr&gt;
        ";
        $OutputExcel .= "
           &lt;tr &gt;
              &lt;td align='left' &gt;$i&lt;/td&gt;
              &lt;td align='left' &gt;".$row-&gt;No."&lt;/td&gt;
              &lt;td align='left' &gt;".$row-&gt;strHorse."&lt;/td&gt;
              &lt;td align='left' &gt;".$row-&gt;Description."&lt;/td&gt;
              &lt;td align='left' &gt;".$row-&gt;Date."&lt;/td&gt;
              &lt;td align='right' &gt;".number_format($row-&gt;Amount,2,'.',',')."&lt;/td&gt;
           &lt;/tr&gt;
        ";
     }
     $OutputPDF .= "
        &lt;tr&gt;&lt;td colspan='6' style='border-bottom:1px solid black;'&gt;&lt;/td&gt;&lt;/tr&gt;
        &lt;tr&gt;
           &lt;td&gt;&lt;/td&gt;
           &lt;td&gt;&lt;/td&gt;
           &lt;td&gt;&lt;/td&gt;
           &lt;td&gt;&lt;/td&gt;
           &lt;td&gt;&lt;/td&gt;
           &lt;td align='right' &gt;&lt;b&gt;Tota: ".number_format($rowTotal-&gt;Total,2,'.',',')."&lt;/b&gt;&lt;/td&gt;
        &lt;/tr&gt;
     &lt;/table&gt;";
  
     $OutputExcel .= "
        &lt;tr&gt;
           &lt;td&gt;&lt;/td&gt;
           &lt;td&gt;&lt;/td&gt;
           &lt;td&gt;&lt;/td&gt;
           &lt;td&gt;&lt;/td&gt;
           &lt;td&gt;&lt;/td&gt;
           &lt;td align='right' &gt;&lt;b&gt;Total: ".number_format($rowTotal-&gt;Total,2,'.',',')."&lt;/b&gt;&lt;/td&gt;
        &lt;/tr&gt;
     &lt;/table&gt;
    ";
  </code></pre>
  
  <p>I am converting it using this </p>
  
  <pre><code> switch($Action){
                case "Clear":
                   break;
  
                case "Export Excel":
                   include_once("reports/". $_REQUEST[radReport] .".php");
                   header("Content-type: application/x-msdownload");
                   header("Content-Disposition: attachment; filename=". $strFilename .".xls"); //gets set inside the report.rpt.php
                   header("Pragma: no-cache");
                   header("Expires: 0");
  
                     echo $OutputExcel;
                     die;
  
                   break;
  
                case "ExportPDF":
                   include_once("reports/". $_REQUEST[radReport] .".php");
                   ini_set('display_errors', '0');
                   header("Content-type: application/pdf");
  
                   require_once('includes/mpdf/mpdf.php');
                   $mpdf = new mPDF('utf-8', $format ,9,'Arial');
                   $mpdf-&gt;setHTMLHeader(getPDFHeader($COMPANYNAME));
                   $mpdf-&gt;setHTMLFooter(getPDFFooter());
                   if($orientation == 'P'){$mpdf-&gt;AddPage($orientation,'', '' ,'','',15,15,20,16,7,9);}else{$mpdf-&gt;AddPage($orientation,'', '' ,'','',30,30,30,30,18,12);}
                   $mpdf-&gt;WriteHTML($OutputPDF);
                   $mpdf-&gt;Output($strFilename."pdf", "I");
  
                   die;
                break;
  
                case "OpenPDF":
                default:
                      $page-&gt;Content .= $Output
                      . js("d('". $_POST[radReport] ."').click(function())");
                  break;
             }
  </code></pre>