Format phone numbers

[Stephen S]

Is it possible to format a phone number field where one just inputs the raw numbers (no spaces)and the display returns parentheses, spaces and hyphens depending on the country. As per Excel:- Format Cell-Number-Special

[andygaunt]

Yes, you can use the Auto enter calculated value option on a field and uncheck the box underneath that says do not replace existing value for field (if Any)

Let ( [Formatted_phone = Filter (Telephone; "0123456789")] ;



"(" & Left ( Formatted_phone ; 3) & ") " & Middle ( Formatted_phone ; 4; 3) & "-" & Right ( Formatted_phone ; 4))

this is very basic and does not capture only 7 characters, extensions or foreign numbers but will get you started.