Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.
User profile for user: TeanafromCapeTown
TeanafromCapeTown Author
User level: Level1 17 points
Hi,
I am a recent convert from Exell to Numbers.
I have downloaded my bank statements to Numbers. The bank statement uses dots as decimal separators, whilst the Numbers default is a comma.
I need to change the Numbers format to dot to avoid having to manually change all in the downloaded spreadsheet.
This spreadsheet also includes my currency as R (ZAR Rands), so either need to remove these or get Numbers to understand it, again to avoid having to remove/change all manually.
Would really appreciate your help.
MacBook Air, OS X Mavericks (10.9.2)
Posted on May 24, 2014 4:13 AM
Question marked as Best reply
User profile for user: Glorfindelor
Glorfindelor
User level: Level1 25 points
Posted on Apr 17, 2017 12:41 PM
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!
View in context
10 replies
Loading page content
Page content loaded
Question marked as Best reply
User profile for user: Glorfindelor
Glorfindelor
User level: Level1 25 points
Apr 17, 2017 12:41 PM in response to TeanafromCapeTown
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!
User profile for user: TeanafromCapeTown
TeanafromCapeTown Author
User level: Level1 17 points
May 26, 2014 2:27 AM in response to SGIII
Hi,
Thanks for your response. Have figured it out with the help of Ross at the V & A Waterfront Apple Store.
System Preferences- Language and Region- at the bottom of the box click "Advanced"- then choose the dot/ comma under Number separators- Decimal and again under drop down box "decimal" under currency.
Regards
Teana
Link
User profile for user: Jimpro7
Jimpro7
User level: Level1 22 points
User profile for user: Jimpro7
Jimpro7
User level: Level1 22 points
User profile for user: armix
armix
User level: Level1 4 points
Nov 2, 2015 2:20 AM in response to TeanafromCapeTown
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
Link
User profile for user: Wayne Contello
Wayne Contello
User level: Level7 26,529 points
May 24, 2014 5:20 AM in response to TeanafromCapeTown
You change the localization in System Preferences > Language & Region
Link
User profile for user: SGIII
SGIII
User level: Level8 35,270 points
May 24, 2014 7:20 AM in response to TeanafromCapeTown
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
Link
User profile for user: Wayne Contello
Wayne Contello
User level: Level7 26,529 points
User profile for user: Wayne Contello
Wayne Contello
User level: Level7 26,529 points
User profile for user: Piniakot
Piniakot
User level: Level1 4 points
Aug 31, 2017 12:25 AM in response to TeanafromCapeTown
Awesome - thank you - that helped!
Link
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.
