I'm from elgium. In Dutch, as probably in some other languages, you write numbers like this: 3,141592, where in English it'd be 3.141592, but the Numbers app only interprets my input as a number when I use a comma, which messes things up when I export it as a csv. How do I make it accept the . instead of the ,? My system language is already set to English.
1 Answer
Numbers seems to use the decimal separator selected in System Preferences:
I didn't find any way to use both comma and period as decimal separators though.
Note that if you change the region from the menu at the top, it also affects things like the default values of locale variables in Terminal and iTerm.
-
thx a lot. I always find it funny how in Dutch, you use the opposite you use in English.– bigblindJun 13, 2013 at 17:43