External Data formatting

[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

 

[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.

 

[dlw]

edit / replace / leave the Replace With part blank