View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dale Dale is offline
external usenet poster
 
Posts: 92
Default want to change phone format ***-***-**** to 1**********

I am new to excel and I have a database that I am trying to convert to a
contact list. The phone number format is not compatable. I tried the "auto
correct" option in Tools after highlighting my column of numbers as well as
the "find/replace" option under editing. Neither worked. Thanks
Dale