change csv list separator in excel 2007 Dutch version

  • Thread starter Thread starter john
  • Start date Start date
J

john

I have Windows XP english version and office 2007 Dutch version.

When creating a csv file from excel 2007 file a semi colon (;) is used as
list separator instead of a comma (,).
I already tried to change the list separator to a comma via Control
Panel>Regional and Language options>Customize
This does not work.

When I change my current format to English (Control Panel>Regional and
Language options) the list separator in the csv file changes to a comma.

Is there a workaround so that I don't have to change the format every time?

Thanks
John
 
Won't you have a problem with any decimal numbers such as 123,24 which
you might have in your data set?
By using a semicolon for saving to CSV this problem is avoided,
conversely switching the regional options changes both this comma to a
decimal point . and the semicolon to the 'normal' comma for a csv.

Sorry I don't have a silver bullet to this one.

Adam
 
Back
Top