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

It seems like your phone "number" is actually numeric text.

Try this:
Select the cell(s)
Format them to Phone Number
<fomat<cells<number tab
Category: Special
Type: phone number

While the cells are still selected...
<data<text-to-columnsClick [Finish]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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?