MrExcel Publishing
Your One Stop for Excel Tips & Solutions

CSV files


Posted by Mike on February 12, 2002 7:38 AM

On my computer when I open a CSV file it automatically open the file correctly(each vale is in a separate column and the comma is missing). A coworker opening the same file results in all the values in one column including the comma. There must be a setting that automatically recognizes *.csv files and recognize the comma as a delimiter that is set on my computer but not my coworkers but I don't know where to look.


Posted by Dave on February 12, 2002 7:47 AM

Open his Regional Settings control panel. Examine
the "Number" tab and make sure that the "List
separator" field is set to a comma (,).

Posted by Mark W. on February 12, 2002 7:47 AM

Just a guess...

Open his Regional Settings control panel. Examine
the "Number" tab and make sure that the "List
separator" field is set to a comma (,).

Posted by Mark W. on February 12, 2002 7:49 AM

Dave, looks like my posting clobbered yours...sorry! [nt]

Posted by Mark W. on February 12, 2002 7:49 AM

Dave, looks like my posting clobbered yours...sorry! [nt]

Posted by Dave on February 12, 2002 7:51 AM

Re: no problem. :-) [nt]

Posted by Dave on February 12, 2002 7:51 AM

Re: no problem. :-) [nt]

Posted by Mike on February 12, 2002 8:15 AM

Thanks

Thanks my coworker was located in Belgium where the default list separator is a semi-colon rather than a comma. I never would have consider the regional settings as a source for this problem

Posted by Mike on February 12, 2002 8:15 AM

Thanks

Thanks my coworker was located in Belgium where the default list separator is a semi-colon rather than a comma. I never would have consider the regional settings as a source for this problem