View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default How to format a phone number in Excel

And yet another way......

="("&LEFT(A1,3)&") "&MID(A1,4,3)&"-"&RIGHT(A1,4)

Vaya con Dios,
Chuck, CABGx3



"tfanatik" wrote:

I can't get a column of numbers, 9999999999, to format as a phone number,
(999) 999-9999. I've tried phone number format, as well as what I found in
this discussion group and nothing has worked. Any new suggestions?