format problems importing Excel to Outlook

Topic

New Reply

I am very new at this so please bear with me. I have a “database” in Excel and want to import into Outlook. Everything imports fine except the formatting of the phone numbers and the zipcodes. I have tried changing the cell format in Excel from special zip and special phone to text, number, and general. In all instances the phone numbers look similar to this: 13621483.000. If anyone could tell me how to correct this problem or what it is that I’m doing wrong I would be greatful.

Reply | Quote

Replies

Have you tried editing the table in design mode ?
From this, you can set the format to apply to all entries in each field of the table. There are some formats that ship with Access (no where near as many as Excel though) but others can be created. there is a seperate option to control decimal places – presumably you want zero.
HTH

Reply | Quote

Oops! I should have posted this on the Outlook forum! I’m importing from Excel to Outlook. I’ll try again there. Thanks for you help, fatherjack.

Reply | Quote