Bizzare Excel prob

[Naoise]

In the French version of excel csv files are delimited by a ; rather than , - is there anyway that I can modify this through some setting or other?

Thanks,
Naoise

 

[xlbo]

This will be a computer setting NOT an excel setting - csv files are independant of excel - its just that they happen to be able to be imported into it

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[Naoise]

Sorry I should have been more specific, I meant that in the French version of Excel csv files are exported, ie when you click save as, with the delimiter as ; not , - is there anyway I can change this?

Thanks for replies,
Naoise

 

[xlbo]

Still a computer setting I believe - excel just picks up what your computer has set as the delimeter. Maybe something under "Regional Settings" ??

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[pr24]

It's regional settings. Press the button to the right of language selection. Almost at the bottom there should be a field where you can change the delimiter sign.

Sorry for poor explanation, but my XP is in Norwegian...

 

[Naoise]

Yep, regional settings, cheers.