MrExcel Publishing
Your One Stop for Excel Tips & Solutions

CSV problem

Posted by Al on June 04, 2001 11:25 AM

I am the only one who cannot open a CSV file correctly.
All the data goes in column 1

Anyone know how to fix this?


Posted by Mark W. on June 04, 2001 11:43 AM

How are you opening it -- by double-clicking it's
icon? If so, is Excel running at the time?

Posted by Al on June 05, 2001 7:22 AM

I found an answer - here it is:

Make sure you have the same list separator and decimal separator as the people the open process *does* work for (change them both in your regional settings).