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.
How to make Numbers accept the “.” instead of the comma “,” when inserting data
numbers
Related Solutions
As far as I know there is no way to make the desired changes all at once, but there is a way that you can make things significantly faster than creating a brand new chart.
As it appears you've already done, copy and paste the chart into your Numbers worksheet. Depending on the chart you've created, select an individual line, bar, pie segment etc. and open the chart pane in the inspector. Here's a screenshot of what that looks like (with "Example 2" being the copied and pasted chart):
As you can see, in the field labeled "Data," Table 1 is referenced. This source can easily be changed to a different table. Just delete the listed source and select the new source of data from your worksheet (you don't have to type in the source). Depending on your chart you may also want to change the data source for the x-axis labels. This is also controlled by the inspector. That can be changed here:
While you'll have to change the data source for each line of the chart, it's certainly faster than creating a whole new chart and having to format it the way you'd like.
You can use the Search/Find functionality (Cmd-F) in Numbers to replace the + with "nothing". Don't worry about + in formulas, they won't get replaced. Summing the the rows should work ok afterwards.
Related Question
- How to handle Numbers’ automatic Data Formatting
- In Numbers, is there a way to get the row instead of the value when using a MAX or MIN Function
- In Numbers, how can I show a formula instead of the result
- On Pages, inserting a graph from Numbers gives a black line at the bottom
- How to make two cells edit and display the same information in Numbers
- How to import data into numbers properly
- Open text file in Numbers when it is space delimited, but some fields are strings in quotes with spaces
Best 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.