Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
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. 
Photo of Johnny DeVilla

Johnny DeVilla

  • 142 Points 100 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 662 Points 500 badge 2x thumb
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],") "),"(")


Photo of Johnny DeVilla

Johnny DeVilla

  • 142 Points 100 badge 2x thumb
That did it, thank you for the help!!
Photo of Johnny DeVilla

Johnny DeVilla

  • 142 Points 100 badge 2x thumb
Would this Right(Left([File Path],"/")&"\" change my slashes in a file path to the opposite? 
Photo of dwhawe

dwhawe, Champion

  • 662 Points 500 badge 2x thumb
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.