Forum Discussion
CSV file is dropping zeros on zip codes when imported
Hi, I have a csv file that I eventually need to reformat as an iif file in order to upload it to outlook. There is a column in the file that contains zip codes, some have leading zeros. I have t...
What I have done so far has not worked-
Here is what I did-
Data-> From text/CSV-> Selected the file-> Transfrom -> selected the column-> on the transform ribbbon data type= text-> Close and load-> I get an excel sheet with the zeros -> save as csv and the zero are lost again
Here is what I did-
Data-> From text/CSV-> Selected the file-> Transfrom -> selected the column-> on the transform ribbbon data type= text-> Close and load-> I get an excel sheet with the zeros -> save as csv and the zero are lost again
ABcomputer You went for the PQ solution anyway. You'll find he Finish button in the Text import option.
Anyway, you managed to import the numbers with the leading zeroes. And you say that when you save the file as a CSV, the leading zeroes disappear. I've never tried to do this myself and can't explain what's happening. Saving as a CSV should just create flat text. No formatting or intelligence whatsoever. But perhaps I'm wrong.