I have exported item list as a csv (as well as tab delimited) but when I import it to excel I loose leading zeros in my item lookup codes. Is there a way to avoid this, thx.
- posted
17 years ago
Missing Leading zero when importing in excel
Loading thread data ...
- Vote on answer
- posted
17 years ago
Change the properties of that field to "Text" in Excel.
K> I have exported item list as a csv (as well as tab delimited) but when I
- Vote on answer
- posted
17 years ago
I just want to expand on this a little.
If csv files are set to be opened by excel, changing the format of the column to text wont help after you double click the csv file to open. The method I use for preserving the leading zero is to open a blank excel workbook and then go to the data menu and choose Import external data -> Import data... In the select files of type drop down at the bottom, choose text file and navigate to the file. This will open the text import wizard. Screen one of the wizard defaults to delimited. go to the next screen. Now choose the delimeters, when you change it to comma on a csv file the colums will be seperated by lines in the preview. go to the third screen and click on the column with the upcs. The data should become highlighted. Next change the column data format to text rather than General. Now click finish.
It sounds complicated, but it took me longer to write this explanation than to do it.
Good luck.