AnsweredAssumed Answered

Format phone numbers

Question asked by on Mar 23, 2015
Latest reply on Mar 27, 2015 by philmodjunk


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.