How to keep leading zeros when puting them into an excel file ?
392544Aug 28 2006 — edited Aug 28 2006Hi all,
I must put number data into an excel file. They are formated as zero padded to the left when their length does not reach 10 ; example 0100680072.
The problem is that the zero is not included when I open the file ; it shows 100680072.
I have tried to append an apostrophe before the variable containing the data , and the zero appears :
if lower(substr(fExp,-3)) not in('csv','xls') then
Text_IO.Put_Line( in_file, bTable(i));
else
Text_IO.Put_Line( in_file, ''''||bTable(i));
end if;
But the problem is that the apostrophe also is in the excel data ; and it is not good.
So how to make the zero appear correctly ?
Thank you very much indeed.