excel truncating leading zeros
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.
|