Here is a function to format phone numbers. I picked it up from here: http://www.freevbcode.com/ShowCode.asp?ID=1968 ‘Takes any entered phone number and returns it in ###-#### format‘or (###) ###-#### Public Function FormatPhoneNumber(ByVal sNumToBeFormatted As _   String) As String Dim iNumberLength As Integer ‘Used for the Phone Number length   ‘Trim any leading and trailing spaces sNumToBeFormatted = […]