View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Veena Veena is offline
external usenet poster
 
Posts: 3
Default 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.