View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ac ac is offline
external usenet poster
 
Posts: 18
Default Converting data in column to Phone Format

I have had to do Social Security numbers once and saved this in case I had to
do it again!

On the Format menu, click Cells.
On the Number tab, click Special in the Category list.
In the Type list, click Zip Code, Zip Code + 4, Phone Number, or Social
Security Number.

Hope it helps!