XLS To CSV Error

gaspower

Board Regular
Joined
Jun 10, 2005
Messages
55
Hello,

I am having trouble with this excel file. I am converting it to a cvs file
for an import. The problem is that item numbers 760-762 import fine, but
764-767 are skipped on the import. It shows all items in the csv file, but I
must be missing some formatting on the xls file that is corrupting the csv
file? I attached a link to the file, so if anyone can see the error, I would
appreciate if you could let me know the error?

http://65.18.128.108/2.2/excelfile.xls

Thanks JR
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

anthonya2369

Active Member
Joined
Mar 10, 2005
Messages
321
are you using a macro or just saving it as a CSV through File Menu? I just saved it as a csv and then opened it up in excel again and everything is there. I did notice you have different size fonts for the other 4 but everything looks like it is working fine. I saw no built in macros in the sheet or workbook.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,811
Messages
5,574,452
Members
412,595
Latest member
slim313
Top