Exporting contacts- Phone Number changing!
 

I have exported a batch of contacts from Excel to Outlook. Everything
transfered fine except the phone numbers. They somehow changed from 10
characters to 9, and the numbers all changed, for example "507288xxxx"
changed to "777114336"!
Most of the "new" numbers begin with 777. Please help!

Exporting contacts- Phone Number changing!
 

Have run across a lot of strange things migrating data but this is a first.

#1 - Are your phone numbers in Excel exactly as you showed in your msg (i.e.
no other chars like hyphens, * or /?) If not then it is possible your phone
number field is being treated as a numeric field and recalculated on output
but usually shows a different kind of value.
#2 - If you save your Excel worksheet as CSV - are the phone numbers
correct?
#3 - If the CSV file is correct - simply import that file instead and you
should be OK. If not - you have an Excel issue that needs to be resolved
first.

Karl

__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com


"KC" wrote in message
...
I have exported a batch of contacts from Excel to Outlook. Everything
transfered fine except the phone numbers. They somehow changed from 10
characters to 9, and the numbers all changed, for example "507288xxxx"
changed to "777114336"!
Most of the "new" numbers begin with 777. Please help!

Exporting contacts- Phone Number changing!
 

Karl,
Exporting the file as a .csv solved it. (Sorry the first time I tried it I
had made a mistake and it didn't transfer right so I thought it wasn't
working). Thanks for your help!

"Karl Timmermans" wrote:

Have run across a lot of strange things migrating data but this is a first.

#1 - Are your phone numbers in Excel exactly as you showed in your msg (i.e.
no other chars like hyphens, * or /?) If not then it is possible your phone
number field is being treated as a numeric field and recalculated on output
but usually shows a different kind of value.
#2 - If you save your Excel worksheet as CSV - are the phone numbers
correct?
#3 - If the CSV file is correct - simply import that file instead and you
should be OK. If not - you have an Excel issue that needs to be resolved
first.

Karl

__________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com


"KC" wrote in message
...
I have exported a batch of contacts from Excel to Outlook. Everything
transfered fine except the phone numbers. They somehow changed from 10
characters to 9, and the numbers all changed, for example "507288xxxx"
changed to "777114336"!
Most of the "new" numbers begin with 777. Please help!