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],") "),"(")
I don't think so. It not really a search a and replace type of a function. If you have only one slash, you can concatenate what is left of it with what is right of it with an opposite slash in between. If there are multiple it gets much more complicated.