title: How to keep "zeros" in cells when exporting from PHP to EXCEL?
body: <p>I'm using this simple script to export from PHP to EXCEL file :</p>
  
  <pre><code>&lt;?php 
  header('Content-Type: text/csv;');
  header('Content-Disposition: attachment; filename="TDO-2017-'. $_GET['lieu'].'.csv');
  
  require('../scripts/lib.php');
  ?&gt;
  "NOM";"PRENOM";"E-MAIL";"TELEPHONE";"ADRESSE";"CODE POSTAL";"VILLE"
  &lt;?php
  echo "\n";
  $rq = mysqli_query($connexion, 'SELECT * FROM tui_inscription WHERE lieu = "'. $_GET['lieu'] .'" AND valid = 1');
  while($d = mysqli_fetch_assoc($rq)) {
      echo '"' . $d['nom'] . '";"' . $d['prenom'] . '";"' . $d['email'] . '";"' . str_replace("+33","0", $d['telephone']) . '";"' . $d['adresse'] . '";"' . $d['cpostal'] . '";"' . $d['ville'] . '"'."\n";
  }
  ?&gt;
  </code></pre>
  
  <p>It does the job perfectly, the only problem is the leading zero in phone numbers disappears. I've seen many explanations on how to use other libraries in order to determine the cell's type but as I do not know PDO and the script already works, I first wanted to know if there was a way I could change my code to do the trick.</p>