asked on
Excel CSV File Type set separator ?
I have some *.csv files where the separator is ;
I have the following problem. After I reinstall my OS(Win98) and Excel(XP 2002 version), the files aren't displayed correctly. I mean Excel expects , as a separator now and not ;
Before reinstallation, I had the same program(Excel XP 2002) and the sameOS(Win98) and it worked with ;
So I think I must set somewhere the separator value but I don't know where.
Can you help me ?
Thanks,
Cata
I have the following problem. After I reinstall my OS(Win98) and Excel(XP 2002 version), the files aren't displayed correctly. I mean Excel expects , as a separator now and not ;
Before reinstallation, I had the same program(Excel XP 2002) and the sameOS(Win98) and it worked with ;
So I think I must set somewhere the separator value but I don't know where.
Can you help me ?
Thanks,
Cata
Microsoft Office
Last Comment
cri
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
No problem.
Steve
Steve
catale, the csv separator is defined under ControlPanel|Regional&Lang
Thanks you for answer so fast.