How do I change the decimal separator from a comma to a dot in numbers? I upload my bank statements into numbers and all contain dots. Numbers does not understand the dots.

I had the same problem, and I noticed there are two ways to set region format for Numbers: via the iCloud website settings and in Numbers for Mac. The first one will change the overall region format for iCloud, but if your Numbers file still doesn't show the correct punctuation, this is how I solved. In Numbers for Mac, go to File > Advanced > Language & Region... This way I discovered that it is (still) not possible to set a specific region format if the file is shared under the "collaboration" formula. To "unlock" the region format you need to close all the collaborations for that specific file. This way, you'll be able to set the desired region format.

Hope this helps!

Mine doesn’t have the advance option

I have something alike. However I have dots (.) ir preferences for a while, but it seems that Numbers (from version 3.6) ignoring system preferences. I have Numbers version 3.6 (2557) and could not find the way to solve that

You change the localization in System Preferences > Language & Region

If changing your localization does not solve the problem, perhaps you can post an small example of the downloaded data (changing names to protect privacy).

A short AppleScript may be a good solution here. But it's hard to suggest one without seeing what the downloaded data looks like.

SG

Good job!

.

Awesome - thank you - that helped!