3 Replies Latest reply on Mar 27, 2015 8:45 AM by philmodjunk

    Format phone numbers



      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.