Regional settings messing up my .csv files

[Ingredients]

Hey,
I was hoping someone would know a better workaround for a problem I'm having. When I export .csv files, it replaces the commas with semi-colons as the separators. The problem is described here.

His conclusion is as follows;

On Mac OS X, I haven't been able to discover a way to specify a different list separator symbol. So I just opened the CSV file into TextEdit, chose Edit > Find > Find, and then searched for all semicolons and replaced them with commas. Of course you can also change your computer's region by going to Apple Menu > System Preferences, clicking on International, and then the Formats tab. Here you'll find the Region menu, where you can specify an English speaking region, which you'd probably want to avoid doing.

I'm hoping someone else might know a better solution for this instead of me having to go change my regional settings?

Any help would be much appreciated

 

[wrldwzrd89]

Which application are you using to export the .CSV files? Odds are that application has a setting you can configure to work around this.

 

[Ingredients]

Which application are you using to export the .CSV files? Odds are that application has a setting you can configure to work around this.

I'm using Excel for Mac 2008. I can't see any option to customise the usage of separators on it.

 

[wrldwzrd89]

Well, lookie here... by golly, I think I found it.

If you're using Snow Leopard, go to System Preferences -> Language & Text -> Formats tab -> Numbers section -> Customize button.

 

[Ingredients]

Well, lookie here... by golly, I think I found it.

If you're using Snow Leopard, go to System Preferences -> Language & Text -> Formats tab -> Numbers section -> Customize button.

Well, when I go from United Kingdom (which is what I have changed it to to fix the .csv issue), back to Ireland, the Numbers formats don't change. So there must be some other element that isn't customisable that is effecting it.