title: Spool a long strings with zeroes to excel
body: <p>I'm trying to spool query results into excel file. This file doesn't exist yet, it's created when I run the script, so I can't format it before.</p>
  
  <p>I have a problem with a single column, it's a number, but in case that number is NULL I need to provide String of nine zeroes <code>(000000000)</code>.</p>
  
  <p>Excel saves those zeroes as a single zero, can I somehow fix that? I tried to adding <code>TO_CHAR</code> without any arguments, so excel saves every number as a String instead, but it doesn't work.</p>
  
  <p><code>TO_CHAR(NVL(IDNT_NR, '000000000'))</code></p>
  
  <p>Also tried:</p>
  
  <p><code>NVL(IDNT_NR, CAST(000000000 AS VARCHAR2(9)))</code></p>
  
  <p>Tried putting a single quote before zeroes, still doesn't work.</p>