title: Sql script display leading 0 in excel output file
body: <p>I have sql script "example.sql": <code>SPOOL &amp;1 Select '&lt;.TR&gt;'||'&lt;.TD align="left"&gt;'||column_name||'&lt;./TD&gt;'||'&lt;.TR&gt;' from table1; spool off..</code>which dumps it contents to cshell script "getdata.csh" this is how i get data from sql script to csh script <code>sqlplus $ORA_UID/$ORA_PSWD @${SQL}example.sql ${DATA}${ext}</code> once i extract data from it i create a excel file by combining 3 files  header. html <code>&lt;html&gt;
  &lt;.head&gt;
  &lt;.title)
  Title
  &lt;./title&gt;
  &lt;./head&gt;
  &lt;.body&gt;
  &lt;.table &gt;
  &lt;.tr&gt;
  &lt;.th&gt;Column Name&lt;./th&gt;
  &lt;.tr&gt;</code>ext file that has query results and trailer.html <code>&lt;./tr&gt;
  &lt;./table&gt;
  &lt;./body&gt;
  &lt;./html&gt;</code> and i save this file as .xls and send it through email as attachment.. Now my problem is Column_name has data that starts with 0 but when i open excel file leading 0 are gone but i wanna keep that 0.. so what can i add to make sure that email attached excel file will have leading 0 when that is opened on the other side.. plz any help would be good</p>