number as string with importing txt file

  • Thread starter Thread starter alfred wallace
  • Start date Start date
A

alfred wallace

How to keep the left zero(s) of a string in a cell by importing a simple
text file ?
thank you in advance
GH
 
Don't import the *.txt file.

Open it directly from File>Open.

The Text to Column Wizard will appear and let you choose the formatting of the
data as Text


Gord Dibben MS Excel MVP
 
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

Import txt file into excel with 281,344 rows 2
creating a txt string from multiple cells separated by | symbol 2
Importing text with text qualifier 2
Populating Cells with Table Data 1
Importing a space-delimited txt. file right-justified into Excel 2
number changes from text to excel 1
How to sort (separate)... 2
Column Widths, Importing ANSI txt files 1

Back
Top