Need auto calculation to format phone number field to insert dashes
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?
Os: Mac OS 10.6
FileMaker Pro 11