I have a nifty auto-enter calculation that imposes our preferred formatting upon phone numbers -- it looks like this:
[@Phone = Self;
@Numbers = Filter(@Phone; "+1234567890")];
Left(@Numbers; 3) & "." &
Middle(@Numbers; 4; 3) & "." &
It works great for U.S. phone numbers; international numbers...not so. The presence of more than 10 digits makes it go haywire, and my brain gets fried when I try to think of how I could accommodate for this occurrence.
If an international number comes to me like this:
I want it to auto-format to
But adding extra numbers to the Right function then louses up domestic numbers. I will be grateful for any thoughts...