Don't know if it's Excel or Outlook

Terilyn · Apr 16th, 2002, 01:25 PM

Hi All,

I created an Excel file with address information, i.e., First Name, Last Name, Address1, etc., to use to import into an Outlook 2000 Contacts file. Everything worked fine except for the phone numbers, which appear in Outlook as -1003425322. I have formated the column in Excel as Phone Number and general and text, but they still end up in Outlook in that form....anybody else have this problem? If so, how did you solve it? TIA.

Terilyn

Anne Troy · Apr 16th, 2002, 01:36 PM

Pretty much: You can't really count on an Excel format being recognized in ANY other kind of file. You can use cell formatting all day to make (000) 000-0000, but other programs will really only see the 0000000000, which Outlook may be seeing as some other type of number. I'm not sure just what format you need for Outlook....sorry.

Apr 16th, 2002, 01:36 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	Pretty much: You can't really count on an Excel format being recognized in ANY other kind of file. You can use cell formatting all day to make (000) 000-0000, but other programs will really only see the 0000000000, which Outlook may be seeing as some other type of number. I'm not sure just what format you need for Outlook....sorry. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 01:25 PM	#1
Terilyn New Member Join Date: Apr 2002 Posts: 1	Hi All, I created an Excel file with address information, i.e., First Name, Last Name, Address1, etc., to use to import into an Outlook 2000 Contacts file. Everything worked fine except for the phone numbers, which appear in Outlook as -1003425322. I have formated the column in Excel as Phone Number and general and text, but they still end up in Outlook in that form....anybody else have this problem? If so, how did you solve it? TIA. Terilyn