It makes sense that this function should be used to format the very cell where you type the phone number, but the function reference seems to describe formating a number coming from another cell.
If in the trigger formula I replace the ‘value’ with a reference to the cell itself with the formula, I get a circular error.
To avoid getting stuck in a circular reference loop, you can use the special value variable in your formula, which contains the value stored within the cell itself.
Sorry, actually, when I inserted more numbers, I got that UK format separation
However, I need a format either like this: 55 51 99909 9090, or 55 51 99909.9090, or with the 51 between parenthesis 55 (51) 99909.9090
btw: I am ControlProcessPav. That’s my account at the office. And I am posting from my personal google account (which is a user, for testing purposes, on the ControlProcessPav apps)