excel truncating leading zeros

  • Thread starter Thread starter Veena
  • Start date Start date
V

Veena

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Text File into Excel loses leading zero on some fields. 4
Leading zeros in Excel 2
Leading Zero in .csv format 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Cells drop leading zeros from numbers 7
Handling hhmmss time format 6
When importing text field Excel chops off leading spaces 1
Import Dropping Leading Zeroes 5

Back
Top