View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deanna Deanna is offline
external usenet poster
 
Posts: 19
Default External Data formatting

I imported data from SQL for my customers and the phone number imported as
'6230000000 since it has a ' in from I can't format as a phone number or
custom format. How can I delete just the ' . I have aprox 2000 cust phone &
fax to change?

Any help would be great!, Thanks