View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Lincoln Mark Lincoln is offline
external usenet poster
 
Posts: 227
Default 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