You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hi!
I have an issue with Numbers 6.0
I need to write a 9 digit number into a cell with dots between every 3 of them. After I separate the number and move to next cell the periods are disappearing. I can't find any resolution for my problem on the web. Any ideas how to removing the auto-formatting of a cell?
To be clear I need something like 123.456.789 - when I leave the cell it transforms into 123456789.
Thanks for help!
Hi Luke,
What do you see in System Preferences > Language & Region > Advanced > General > Number separators?
In my Region, Grouping (thousands separator) is a comma (,).
You can change Grouping (and the decimal separator) for numbers and currency.
By the way, are you typing the dots in numbers? It seems strange that they disappear when you leave a cell 🤔.
Regards,
Ian.
Hi Luke,
What do you see in System Preferences > Language & Region > Advanced > General > Number separators?
In my Region, Grouping (thousands separator) is a comma (,).
You can change Grouping (and the decimal separator) for numbers and currency.
By the way, are you typing the dots in numbers? It seems strange that they disappear when you leave a cell 🤔.
Regards,
Ian.
Hi Luke,
Thanks for the Greenie and your feedback!
Luke_Norge wrote:
since I work in Numbers and the issue is with a cell, it is going to be an app specific formatting function. But here it is an OS global setting. Why? I identified the source of problem wrong and could not find a solution.
Yes, System Preferences > Language & Region is an OS global setting.
You can change Language & Region for each Spreadsheet individually.
Have a play and let us know how it goes for you.
Regards,
Ian.
Hi!
Thanks for help :D
Yup - the periods were vanishing after I left the cell. Now they don't. It is strange that this happened - I use this document since 2016 and I had write numbers in that card without this problem. Yesterday I had some of them xxx.xxx.xxx and some xxxxxxxxx.
P.S. what I think is not intuitive is the solution for cell formatting. It seems like, since I work in Numbers and the issue is with a cell, it is going to be an app specific formatting function. But here it is an OS global setting. Why? I identified the source of problem wrong and could not find a solution.
Anyway - thanks again! :D
A cell is auto-formatting my numbers
