External Data formatting

D

Deanna

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
 
D

Dave Peterson

If it's just a single column, you could:

Select the column
Data|Text to columns|and click finish
Then format the range the way you like.
 
Top