Community
Showing results for 
Search instead for 
Do you mean 
Reply

Formatting US telephone numbers

New Member
Posts: 1
Country: USA

Formatting US telephone numbers

Please tell me how to format US phone numbers using a dash (i.e. xxx-xxx-xxxx) between the three segments of the number. 

 

Also is there a way to automatically format previously entered numbers with the dashes too?

 

Thanks

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Formatting US telephone numbers

Hello Mikepf,

Welcome to the Sage ACT! Online Community!

 

You can set the format for all phone fields by clicking the ellipses (button with 3 dots) icon next to a phone field, then click 'Edit Formats...'.  You can then select the format and set a default.

 

Updating all phone fields to the default format requires copying the individual phone fields to a different un-used field (ex: User 9, User 10), updating the default phone format, then copying the data back into the phone field.  Here is an article with instructions: KB Article 14410

Greg Martin
Sage