Phone with/without area code format
 

Phone field is text without input mask.
If we type 7 digits, I want it to display as ( ) xxx-xxxx
If we type 10 digits, I want it to display as (xxx) xxx-xxxx

Phone with/without area code format
 

Format|Cells|Special|Phone Number

Mark Lincoln

On Sep 4, 1:08 pm, barnabas
wrote:
Phone field is text without input mask.
If we type 7 digits, I want it to display as ( ) xxx-xxxx
If we type 10 digits, I want it to display as (xxx) xxx-xxxx

Phone with/without area code format
 

There are no input masks in Excel, try this custom format

[<=9999999]"( ) "###-####;(###) ###-####



--
Regards,

Peo Sjoblom




"barnabas" wrote in message
...
Phone field is text without input mask.
If we type 7 digits, I want it to display as ( ) xxx-xxxx
If we type 10 digits, I want it to display as (xxx) xxx-xxxx