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

External Data formatting
 

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.

Deanna wrote:

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

External Data formatting
 

edit / replace / leave the Replace With part blank

"Deanna" wrote:

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