cancel
Showing results for 
Search instead for 
Did you mean: 

format of a phone numer

Former Member
0 Kudos

HI our data is like this:

6616314741

I need to display the phone number as 661-631-4741

Where can I create this edit mask?

Accepted Solutions (1)

Accepted Solutions (1)

JWiseman
Active Contributor
0 Kudos

hi Paul,

you can use the picture function...

Picture ({your text field}, "(xxx) xxx-xxxx" )

or

Picture (totext({your number field},0,""), "(xxx) xxx-xxxx" )

cheers,

jamie

Answers (0)