View Single Post
  #1   Report Post  
Frank @ St. Louis
 
Posts: n/a
Default How do I change phone numbers from "xxxxxxxxxx" to "xxx-xxx-xxxx

I am combining three databases on Xcel. Total of 18,000 items/contacts.
Approximately 5,000 show a phone number of "xxxxxxxxxx" which will be
incompatable with the remaining items/contacts that have the phone number
listed as "xxx-xxx-xxxx". I like the latter format. How do I change the
list of 5,000 to "xxx-xxx-xxxx"? I have Excel 2002

Simple question, but I am stuck.

Thanks for your help.

Frank