View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nrodADAA nrodADAA is offline
external usenet poster
 
Posts: 5
Default Phone number not

Hi, I am highlighting a group of numbers I want converted to phone numbers.
Unless I double click each one, it doesn't work. What am I doing wrong? I
am using OS2k, Excel 2k.

Example:
4017252985
4019446103
8028934982
7325169202
9732292361

I would like to see them like this:
(401) 725-2985

I right click/format cells/special/I choose phone number but nothing happens
in the field.