Phone number input mask

[Darth_Beckett]

Ok I have an excel spreadsheet with over 6000 phone numbers that I need to import into a table. I have set up my field with an input mask to display a phone number as (xxx) xxx-xxxx. I have also set up my excel spreadsheet to have the numbers set up like 1234567890 to make it easy to throw in and let the input mask take over. My question is: I have some numbers that have an extension and are set up as 1234567890 x 102. I can take out the "x" and have all of the numbers run together, but what is the input mask syntax to have it display as say "(xxx) xxx-xxxx ext.xxx"?

Thanks

 

[mhartman]

"EXT":\ 99999;;_

Regards

Mark

 

[Darth_Beckett]

Ok so what would be my completed formula...because when I just add "EXT":\ 99999;;_ to the end of mine I get !\(999") "000\-0000" ext":\ 99999;;_ which makes my phone numbers all convert to (___) __6-5497 ext: 83215

 

[mhartman]

Hello:

!\(999") "000\-0000" Ext.: "0000;;_

would be the input mask syntax for what you ask. If you need to tweek it. Search online help for the input mask characters.

Regards
Mark

 

[RaunLGoode]

Related Question

Please forgive me for taking this thread off on a tangent, but I have been trying to find information on Phone Numbers and found this thread.
What Data Type works best for Phone Numbers? I have tied to use "Number" (Long Integer & Double) I have also tried "Currency"
I keep getting an error message stating the "Value you entered isn't valid for this field". This should be a no brainer, but Access 'Help' and my Access Bible don't seem to cover this.

 

[RuralGuy]

It should be a Text field!

 

[RaunLGoode]

Thank You !!

 

[RuralGuy]

You're welcome.

 

[cortevil]

In case anyone looks this up on a search like I did, I found an easier answer.

\(999") "000\-0000" Ext. "9999;;_

Just remove the bang ("!") from the beginning and the mask will fill from left to right instead of right to left.