0's getting truncating during Import

Hi,

I have a requirement like this.

Thru PLSQL i will wirite data to excel file.
Im using tab as seperator for columns.

There is one column which i will have characters.but all the characters
were numbers.
For Example i will have data like this 01234,02345,0012,0234
But if im opening the excel File the leading 0's are getting
truncated.
I need actual data to be preserved in Excel.
For this i have appended single quote for that column.but it was the
deviation from my requirement.

Can any one help me in this context

Regards,
Md.Sam


--
samdani_md
------------------------------------------------------------------------
samdani_md's Profile: http://www.excelforum.com/member.ph...fo&userid=27749
View this thread: http://www.excelforum.com/showthrea...threadid=472579