Phone with/without area code format

[barnabas]

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

 

[Mark Lincoln]

Format|Cells|Special|Phone Number

Mark Lincoln

 

[Peo Sjoblom]

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

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