Format phone numbers
I have a data file with the field "Phone number".
When I enter the phone number into the field I do it as 10 numbers without the dash "-".
Would be most grateful if anyone has a formula to place in the field "Phone number" that would automatically convert the phone number from the 10 digit to the accepted way phone numbers are displayed.
For example: the phone number I enter is 1234567890. I would like to have that appear as 123-456-7890.
I am new to FileMaker and have been trying to figure this out. No luck.
Must be some magic i am missing.