title: Scientific notation when exporting SQL to Excel
body: <p>I have a SQL statement which is exporting data to Excel. The problem is that large numbers get converted to scientific notation when exported to Excel. To avoid that I am using char(39), i.e. single quotes around the number. In addition, also checking for null value so using <code>ISNULL</code>.</p>
  
  <pre><code>ISNULL(char(39) + Rtrim([NumberCol]) + char(39), '')
  </code></pre>
  
  <p><code>[NumberCol]</code> has <code>char</code> datatype</p>
  
  <p>So now if NumberCol is a numeric value I get '000123456789' format which is what I want. But when it is Null then I get ''. I do not want to display '' in Excel rather blank. Please let me know how to do this.</p>