Can i Format Phone Numbers like this

Hi,

I just want the numbers to be displayed in this format (630) 123-1234

I have an input mask for a field call Cell Phone:
!\(999") "000\-0000;0;_

When I use that field to print on my report, I'm getting this to display?
(999) 000-0000(630) 123-1234

please give some suggestions.

Thank you!

Try this code this code is basically for converting the phone number format like this (###) ###-####.

Sub Format_Phone()

' converts most default phone columns to US/CAN standard (###) ###-####

Please Login or Register  to view this content.