MrExcel.com - 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?

Thanks

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).