I want to save an excel sheet as a csv file.
I choose 'Save as', select CSV file format and click on 'Save'.
When I open this saved file in textpad I see that excel used the ';' (semicolon) as delimiter for the cells.
I searched google for this problem and it was said that the list separator in the regions additional format settings should be changed.
I changed the systems list separator to ',' (comma), restarted excel tried to save it again, but still the semicolon is there. I restarted my computer, tried to save it again, but still the semicolon is there.
I searched all options of excel to set the list separator manually, but nothing there.
- How to set the list separator for excel 2010?
- Why does excel ignores my changed list separator? (and how to repair it?)