The Computer Oracle

How can you change Mac excel 2011 to separate using commas, not semicolons?

--------------------------------------------------
Hire the world's top talent on demand or became one of them at Toptal: https://topt.al/25cXVn
and get $2,000 discount on your first invoice
--------------------------------------------------

Take control of your privacy with Proton's trusted, Swiss-based, secure services.
Choose what you need and safeguard your digital life:
Mail: https://go.getproton.me/SH1CU
VPN: https://go.getproton.me/SH1DI
Password Manager: https://go.getproton.me/SH1DJ
Drive: https://go.getproton.me/SH1CT


Music by Eric Matyas
https://www.soundimage.org
Track title: Dreaming in Puzzles

--

Chapters
00:00 How Can You Change Mac Excel 2011 To Separate Using Commas, Not Semicolons?
00:26 Accepted Answer Score 43
01:47 Answer 2 Score 6
02:02 Thank you

--

Full question
https://superuser.com/questions/988756/h...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#microsoftexcel #csv

#avk47



ACCEPTED ANSWER

Score 43


Excel for Mac currently has no setting to change the CSV separator from the app itself.

The chosen value separator depends on your Region and your region's default number separators.  To change them, go to “System Preferences” > “Language & Region”:

System Preferences > Language & Region

Then you need to verify the number separators in “Advanced …” > “General”.

Advanced > General

Here are the rules Excel uses to determine how it saves CSV files:

  • If your language / region / locale uses comma (,) for decimal separation (i.e., π (pi) is displayed as 3,1416), then Excel will save using semi-colons (;)
  • If it uses a dot (., a.k.a. full stop or period), then it will delimit with commas (,).

Note:

  • You need to change your general region for it to work. For example, if your region is Germany (which uses , for decimal separation), Excel will always use ; for CSVs, even when changing the decimal point under “Advanced” settings. You could, for example, if you want , as a CSV separator, choose the United States as a region.
  • You need to relaunch Excel for it to notice. Quit the app, change the region, then start it again.



ANSWER 2

Score 6


I've tried the accepted answer with no success. (High Sierra + Excel 16.10) My only option has been to use open office, far away from Excel in this feature.