How do I open a csv file and not have leading zeros eliminated


G

Guest

I have a File that I down Load from another system (AS400) which I converted
to CSV Format. Some of the Alphanumeric fields (cells) have legimitate
values that start with 0 (zeros).
When I open the file in EXCEL it strips the leading zeros from those fields.
How do I prevent that.?

I tried using " as a delimiter but it did not work.
 
Ad

Advertisements

G

Guest

Try this:

Change the file extention to .TXT (from .CSV)

When you open the file, the Text Import Wizard will engage.
On Step_3, select your column and set it for TEXT

That will prevent Excel from changing it to numeric values.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Ad

Advertisements

G

Guest

Change the extension of your data file from .CSV to .TXT

This will cause the Text Import wizard to launch. On step 2 of the wizard,
check Comma for the delimiter. On step 3, select the field with the leading
zeros, then click Text. When you finish importing the data, that field will
still have the leading zeros.

Hope this helps,

Hutch
 

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

Top