Formatting a Phone Number

K

KRB

My phone number field has all 10 digits together: 5552311212. I'm wanting to
add Parenthesis around the area code and a dash after the prefix so my phone
number will display like (555)231-1212. Is there a way to do this?

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I parse a phone number? 6
Extract phone number from word file 2
phone number formatting 2
Contact Phone Number Auto Format 0
formatting a phone number in a string 2
Determine Length Of Mail Merge Field 3
How to change "1" to "9" for long distance prefix. 3
Omit blank information 10

Top