AnsweredAssumed Answered

Need auto calculation to format phone number field to insert dashes

Question asked by holgerhelmut on Jun 13, 2010
Latest reply on Jun 14, 2010 by holgerhelmut

Title

Need auto calculation to format phone number field to insert dashes

Post

I have a database with 10,300 US records. The text field "PhoneNumber" needs to be auto re-formatted. Currently the numbers are all 10 digits without any spaces but also without the desired dashes. Meaning numbers are listed as 2136223750 and I need them to read 213-622-3750. 

I can't figure out the auto calculation. Anyone?

Super thanks.

 

Os: Mac OS 10.6

FileMaker Pro 11

Outcomes