Milly,
This method you suggest will not work as the format of the details exported
is "General" with a " ' " infront of the details exported. When you apply a
custom format it is no longer general and when you import back into outlook
the formatting is ignored and is displayed as a number.
When displayed like this, outlook misses off the +44 (0) at the begining of
the phone number and display it as 1234 567890 (dropping the 0) instead of
+44 (0)1234 567890
Any ideas?
Regards
John
"Milly Staples - MVP Outlook" wrote in message
...
You can export to Excel and set the column formatting to accomplish what
you want, then import them back to Outlook.
--
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375
"John" wrote in message
...
Hi,
Can anyone tell me if it is possible to carry out a batch update of
contacts.
I have over 2000 contacts and would like to format their telephone
numbers.
At the moment all the nember are in the format 09999 999999 I need to
format them using +44(0)9999 999999
can this be done as a batch?
Regards
John