title: Exporting SQL data to Excel without losing the 0 in the phone number
body: <p>I currently have a simple database which stores a customers basic table. However when ever I try to export my sql query to Excel the phone number field always appears without a 0.</p>
  
  <p>My SQL query results:</p>
  
  <pre><code>ID | Name |Address |DOB         | Gender |Phone_Number   |
  ---------------------------------------------------------
  01 | Max  |Abc Road| 2000-12-19 | Male   |07777 893 8902 |
  02 | Sam  |TBH Road| null       | Male   |077778938902   |
  03 | Doe  |Dr  Road| 1999-11-13 | Male   |077778 938902  |
  </code></pre>
  
  <p>What I get in Excel:</p>
  
  <pre><code>ID | Name |Address |DOB         | Gender |Phone_Number   |
  ---------------------------------------------------------
  01 | Max  |Abc Road| 2000-12-19 | Male   |07777 893 8902 |
  02 | Sam  |TBH Road|            | Male   |77778938902    |
  03 | Doe  |Dr  Road| 1999-11-13 | Male   |077778 938902  |
  </code></pre>
  
  <p>However what I want to get this without having to format the cells in excel:</p>
  
  <pre><code>    ID | Name |Address |DOB         | Gender |Phone_Number   |
      ---------------------------------------------------------
      01 | Max  |Abc Road| 2000-12-19 | Male   |07777 893 8902 |
      02 | Sam  |TBH Road|            | Male   |077778938902   |
      03 | Doe  |Dr  Road| 1999-11-13 | Male   |077778 938902  |
  </code></pre>
  
  <p>My SQL query at the moment is as following:</p>
  
  <pre><code>SELECT 
  ID,
  isnull(Gender,'') Gender,
  isnull(Name,'') Name,
  isnull(Address,'') Address,
  isnull(DOB,'') DOB,
  isnull(Gender,'') Gender,
  isnull(Phone_Numer,'') Phone_Number
  FROM CUSTOMER;
  </code></pre>