Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000
I want to display phone numbers on a report as 000-000-0000 instead of (000) 000-0000. I just starting out with formulas any insight would be helpful.
Forum Discussion
This is how I would do it with a Formula-Text field:
Substitute your phone number field with [Home Telephone] and please see the strategic space in the embedded Right statement
Right(Left([Home Telephone],")")&"-"&Right([Home Telephone],") "),"(")
Substitute your phone number field with [Home Telephone] and please see the strategic space in the embedded Right statement
Right(Left([Home Telephone],")")&"-"&Right([Home Telephone],") "),"(")
That did it, thank you for the help!!