Ask Your Question

Telephone Number edit pattern? [closed]

asked 2014-03-22 21:07:37 +0200

Ronnie James Dio Fan gravatar image

Hi all!

How do I create an edit pattern for a United States telephone number in Base? How does the field need to be defined for this to work correctly? Text? Decimal? Number? Something else?

I want it to display in the entry form, queries and reports as 999-999-9999 with the dashes/separators. The data in the table can be in 9999999999 format (without the dashes/separators.)

Thanks in advance!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 08:47:51.136089

1 Answer

Sort by » oldest newest most voted

answered 2014-03-23 15:40:20 +0200

ROSt52 gravatar image

updated 2014-03-23 15:40:39 +0200

I would make 2 columns: A for 9999999999 and B for the 999-999-9999
in B 1 enter: =LEFT (A1,3)&"-"&MID(A1,4,3)&"-"&MID(A1,7,4)
Depending on your separator setting you need to replace "," by ";"

edit flag offensive delete link more


Wow! Thanks for the reply!

Ronnie James Dio Fan gravatar imageRonnie James Dio Fan ( 2014-03-23 16:40:47 +0200 )edit

Question Tools

1 follower


Asked: 2014-03-22 21:07:37 +0200

Seen: 590 times

Last updated: Mar 23 '14