Discussions

Expand all | Collapse all

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

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

    Posted 08-03-2018 21:07
    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. 


  • 2.  RE: Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000

    Posted 08-03-2018 22:19
    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],") "),"(")




  • 3.  RE: Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000

    Posted 08-06-2018 15:18
    That did it, thank you for the help!!


  • 4.  RE: Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000

    Posted 08-06-2018 18:22
    Would this Right(Left([File Path],"/")&"\" change my slashes in a file path to the opposite? 


  • 5.  RE: Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000

    Posted 08-06-2018 21:04
    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.