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 = […]