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.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

A cell is auto-formatting my numbers

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!

Posted on Feb 2, 2020 12:58 PM

Reply
Question marked as Top-ranking reply

Posted on Feb 2, 2020 10:50 PM

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.

3 replies
Question marked as Top-ranking reply

Feb 2, 2020 10:50 PM in response to Luke_Norge

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.

Feb 3, 2020 1:36 AM in response to Luke_Norge

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.



Feb 3, 2020 12:33 AM in response to Yellowbox

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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.