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!