Skip to main content
Question

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

  • August 4, 2018
  • 0 replies
  • 82 views
Forum|alt.badge.img+3
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. 
    This topic has been closed for replies.

    • DavidHawe
    • Registered
    • August 4, 2018
    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],") "),"(")


    Terms & ConditionsAccessibility statement