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?