Microsoft KB Archive/169817: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 44: Line 44:
== SYMPTOMS ==
== SYMPTOMS ==


When importing data containing phone numbers or postal (zip) codes from other programs such as Microsoft Access or Microsoft Excel, the numbers may be displayed with ".000" appended to the end. The numbers will not contain any parentheses or hyphens and in some cases the number may be completely different from the number in the original program.
When importing data containing phone numbers or postal (zip) codes from other programs such as Microsoft Access or Microsoft Excel, the numbers may be displayed with ".000" appended to the end. The numbers will not contain any parentheses or hyphens and in some cases the number may be completely different from the number in the original program.


</div>
</div>
Line 51: Line 51:
== CAUSE ==
== CAUSE ==


This problem occurs because Outlook does not recognize the numbers being imported as phone numbers or postal codes, even if they look correct when viewed in the original program; this happens when the number is imported from a Numeric-type field. An example of this is when a field in Microsoft Excel is formatted as a phone number even though it is typed as a 10-digit number. In Microsoft Excel, it is possible to use a &quot;Phone Number&quot; format; once this format has been applied, you may type a number such as 5551234567 and Microsoft Excel will display it as (555)123-4567. When this number is imported into Outlook, it is interpreted as 5551234567 instead of (555)123- 4567. If a phone number is typed into Microsoft Excel with the parentheses and hyphens, Outlook will interpret it as a phone number.
This problem occurs because Outlook does not recognize the numbers being imported as phone numbers or postal codes, even if they look correct when viewed in the original program; this happens when the number is imported from a Numeric-type field. An example of this is when a field in Microsoft Excel is formatted as a phone number even though it is typed as a 10-digit number. In Microsoft Excel, it is possible to use a "Phone Number" format; once this format has been applied, you may type a number such as 5551234567 and Microsoft Excel will display it as (555)123-4567. When this number is imported into Outlook, it is interpreted as 5551234567 instead of (555)123- 4567. If a phone number is typed into Microsoft Excel with the parentheses and hyphens, Outlook will interpret it as a phone number.


</div>
</div>

Latest revision as of 10:04, 21 July 2020

Knowledge Base


OL97: Imported Phone Numbers and Postal Codes Have .000 Appended

Article ID: 169817

Article Last Modified on 1/19/2007



APPLIES TO

  • Microsoft Outlook 97 Standard Edition



This article was previously published under Q169817

SYMPTOMS

When importing data containing phone numbers or postal (zip) codes from other programs such as Microsoft Access or Microsoft Excel, the numbers may be displayed with ".000" appended to the end. The numbers will not contain any parentheses or hyphens and in some cases the number may be completely different from the number in the original program.

CAUSE

This problem occurs because Outlook does not recognize the numbers being imported as phone numbers or postal codes, even if they look correct when viewed in the original program; this happens when the number is imported from a Numeric-type field. An example of this is when a field in Microsoft Excel is formatted as a phone number even though it is typed as a 10-digit number. In Microsoft Excel, it is possible to use a "Phone Number" format; once this format has been applied, you may type a number such as 5551234567 and Microsoft Excel will display it as (555)123-4567. When this number is imported into Outlook, it is interpreted as 5551234567 instead of (555)123- 4567. If a phone number is typed into Microsoft Excel with the parentheses and hyphens, Outlook will interpret it as a phone number.

RESOLUTION

If the number is typed into the original program with the parentheses and hyphens, Outlook will interpret it correctly. If you are importing a large amount of data and it is not practical to manually add the parentheses and hyphens, try exporting the data from the original program as a Comma Separated Value (.CSV) file. Most programs such as Microsoft Access and Microsoft Excel will include the parentheses and hyphens as part of text file, thus making it possible for Outlook to properly interpret the data.

For information on exporting data from your original program as a comma separated value text file, consult the documentation supplied with that program.


Additional query words: ODBC DBASE FOXPRO

Keywords: kbinterop kbprb KB169817