Open CSV correctly

[Amirallia]

Hello

When I double-click on a CSV file, separate with ";", each line of my
file appears on a single column, but if I change the separator to ","
all is ok.

I change the Separator list to ";" in the regianl settings but no
changes !

Any idea to configure my Excel to take the ";" as separator?

 

[Dave Peterson]

When you tried this, did you have excel closed?

This technique has worked for me. Maybe just trying it again (with excel
closed) will work.

If it still fails, you can still
select the column
data|text to columns
delimited by ;

(an additional step, until you find the solution.)

 

[Amirallia]

Dave Peterson avait soumis l'idée :

When you tried this, did you have excel closed?

This technique has worked for me. Maybe just trying it again (with excel
closed) will work.

If it still fails, you can still
select the column
data|text to columns
delimited by ;

(an additional step, until you find the solution.)

It doesn't work...

With Excel 2003 if I change the Separator list in regional settings, it
takes effects when I open the csv file, but with Excel 2000 no effects

 

[Dave Peterson]

I don't have xl2k anymore.

Maybe someone else can offer a suggestion.

 

[P D Sterling]

FWIW, because I am an extremely elderly person, I always boot excel and
then open the .csv file and never have any problems, regardless of
delimiter. If I double-clicked on a .csv file, it would open my text
editor, anyway.

Regards,

P D Sterling
Dallas TX

 

[m96]

it's a reginal settings problem.

look at http://support.microsoft.com/kb/266200/en-us

if you don't want to change your reginal settings your other option
would be using macro's

look at http://support.microsoft.com/kb/291296/en-us

hope this helps.

cheers.