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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No problem.
Steve
Steve
catale, the csv separator is defined under ControlPanel|Regional&Lang uageSettin gs: RegionalSettings (or similar), see under 'List Separator'
ASKER
Thanks you for answer so fast.