Community
Showing results for 
Search instead for 
Do you mean 
Reply

Loss of phone number formatting on import of records

Copper Contributor
Posts: 56
Country: USA

Loss of phone number formatting on import of records

I recently imported records from an Excel table. I have two fields in the table, phone number & fax number. They are mapped to import into their appropriate fields in ACT. In the Excel table the two phone number fields are formatted as: xxx-xxx-xxxx. I would like them all to reflect my default ACT format for these fields; (xxx) xxx-xxxx. This did not happen when I did the import. Other than manually changing these records, how can I correct these mis-formatted fields? Is their an add-on which does this? Or does ACt have a utility which can re-format all records, to have the desired phone number format?
Silver Super Contributor
Posts: 2,328
Country: USA

Re: Loss of phone number formatting on import of records

I have an addon that I've written that will fix the formatting of all the phone numbers.  I sell it for $79.95.  Contact me offline if you're interested.

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!