How do I open a csv file and not have leading zeros eliminated
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
"AS400_EXCEL_John_B" wrote:
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.
|