Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2003
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    zip code (Outlook 2000)

    I work for an engineering company downunder and put mailing details for over 1300 clients into Outlook .

    I produced the contact list by exporting an excel spreadsheet so I could add existing info from other excel sheets then imported the final spreadsheet back into Outlook. It worked fine, except that Outlook adds .000 to our four digit zip code (and more recently .0000).

    Is this an American thing, an Outlook thing or something I've done?

    Any ideas would be appreciated.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: zip code (Outlook 2000)

    it sounds like maybe excel is reading the zip as a number instead of a text field and using decimal places. (zip codes in excel are problematic, especially with those in the northeast us that begin with 0)

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: zip code (Outlook 2000)

    If it is as MaryJ suggests and it's being read as a number, you can easily change the zip code to text in the Excel spreadsheet (in case you don't know how and started to type em all in again).
    Just select all the entries, right click and select Format Cells from the drop down menu. Then, on the Number tab, change the type to text. This might force Outlook to import as a text field.
    HTH
    Silverback

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •