0's getting truncating during Import

's Computer Specifications

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.php...o&userid=27749
View this thread: http://www.excelforum.com/showthread...hreadid=472579

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How I import data without truncating zero in the beginning	Mohsin Habib	Microsoft Access	2	16th Jan 2008 05:16 PM
How I import data without truncating zaro in the beginning	Mohsin Habib	Microsoft Access	1	16th Jan 2008 10:16 AM
Help with truncating	ken	Microsoft VB .NET	4	24th Jan 2006 05:33 PM
Access 2003 truncating data using ODBC import	=?Utf-8?B?Um9nZXJpblRleGFz?=	Microsoft Access External Data	0	11th Jan 2005 11:45 PM
Truncating	=?Utf-8?B?RnJhbWU=?=	Microsoft Excel Worksheet Functions	3	25th Jan 2004 04:03 AM