Link to home
Start Free TrialLog in
Avatar of catale
catale

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
ASKER CERTIFIED SOLUTION
Avatar of Steve Knight
Steve Knight
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of catale
catale

ASKER

Ok.
Thanks you for answer so fast.
No problem.

Steve
catale, the csv separator is defined under ControlPanel|Regional&LanguageSettings: RegionalSettings (or similar), see under 'List Separator'