Hi,

I am trying to use the import from text file into an excel sheet. I
read many queries and figured out how to import the values as text
without dropping the leading zeros.
Please suggest a way where i can import all the values as "text" type.
I want to avoid creating an array as the size of my text file varies
from time to time.
So i will not be sure how big the array must be.

Please suggest.
Thanks .
regards,
veena.

one way:
At the import dialog box, select all of the imported columns, then press the
"Text" radio button before you import.

GMet

"Veena" wrote in message
om...
Hi,

I am trying to use the import from text file into an excel sheet. I
read many queries and figured out how to import the values as text
without dropping the leading zeros.
Please suggest a way where i can import all the values as "text" type.
I want to avoid creating an array as the size of my text file varies
from time to time.
So i will not be sure how big the array must be.

Please suggest.
Thanks .
regards,
veena.