title: Table cells format when exporting jQuery Datatable to Excel
body: <p>I have a datatable in my application that I need to export to Excel but when the datatable is exported in excel, the format type for each cell is 'General'. However, I want all my cells to be displayed in 'Text' format in Excel. </p>
  
  <p>I tried converting my data to String but it still displays the result in General. If I try to convert my data to Int then it does displays it in Number format in Excel but I want everything in Text format. </p>
  
  <p>Here's the function I'm trying to change the data type:</p>
  
  <pre><code>{
     "targets": 13,
     "render": function (data, type, row){
         var d = data.toString();
         return d;
         }
  }
  </code></pre>
  
  <p>Here I'm targeting to one column only. However, I want to target all my columns. Even targeting a single column won't work.</p>
  
  <p>Any help would be appreciated.</p>