probably easy manipulation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a field of phone numbers looks like 9999999999. I want to
change the field so the phone numbers look like this 999/999-9999. Please
help me.

Thank you,
Nick
 
Change the data type for that field to text if it isn't already. Then type in
!999/\ 000\-0000;;_ for the input mask for that field and save the table.

Andre
 

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

Formatting Phone Numbers 1
Access And Phone Numbers 5
Sort with Nulls at End 2
Reports and Phone Number Format 3
Format Telepone Number 3
Removing Symobls from phone numbers 4
Word Create a Phone Book using MailMerge in word 2007 0
Find Phone Number in Database 1

Back
Top