how to set CSV delimiter in OSX Lion? I live in Indonesia and we use the dd/mm/yyyy date format as opposed to America's mm/dd/yyyy. Questions:


I changed my Language settings to Indonesia region so that this date format would be recognized as a date in Excel. It worked, but somehow Excel won't recognize a comma as a delimiter for CSVs anymore. How shall I solve this?
Is there a way to get Excel to recognize this date format without changing the Language settings?


Thanks
In Excel 2011, open a workbook,

Click on Format > Style and you get this window



In here click format again and you get this window



Pick the Date format you want,
or make a custom format in your case dd/mm/yyyy