Importing from a Notepad file

  • Thread starter Thread starter cnelson
  • Start date Start date
C

cnelson

I want to import data from a comma separated Notepad file. When I import into Excel I find that the leading zeroes are dropped and I don't want this to happen. I have some fields that should be "000" not "0".

Is there a way to import without losing all these zeroes?
 
When youi Import or open a *.txt file the Text Wiizard will pop up and
in Step 3 under Column Data Format you can select Text.

Leading zeros will be held.


Gord



On Thu, 8 Dec 2011 12:07:53 -0800 (PST),
 
You did say a comma separated file which is most likely *.csv

Change the csv extension to txt then import or open directly in Excel.


Gord
 
You did say a comma separated file which is most likely *.csv

Change the csv extension to txt then import or open directly in Excel.

Gord
Click to expand...

It worked! I didn't realize that I had to change every column to TEXT.

Thanks
 
Back
Top