PHONE NUMBER formatting

C

czbacnik

All I want to do is have my phone numbers appear (555) 555-5555, but
for some reason I keep getting all these weird -- in between the
numbers. I read that I should put
"(999) 999-9999"! as an input mask, but that didn't work. Does anyone
have a suggestion?

I appreciate the help!

Thanks,

Carla
 
B

Beege

Carla,

Format / cells / special / phone numbers
or custom
[<=9999999]###-####;(###) ###-####
you just cant put in the dash when entering the number, enter numbers only.

Beege
 
C

czbacnik

Huh...when I use my table under design view, format does not have any
option.

Should I be making an input mask instead? Right now, when I input a
phone number in forms, it will say (###) ###-#### and won't let me
overwrite it. I must have screwed something up? Any advice?
 

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

Remove Parentheses from Phone Number 7
formatting a phone number in a string 2
Formatting phone numbers 5
Removing parentheses in a phone number 7
phone number formatting 2
Input of phone numbers 3
Word Create a Phone Book using MailMerge in word 2007 0
how to change format of data already entered 5

Top