Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

ZIP Code Export from Mappoint loses leading 0

This is a discussion on ZIP Code Export from Mappoint loses leading 0 within the MapPoint Desktop Discussion forums, part of the Map Forums category; Any help that someone can give would be GREATLY appreciated. One of our clients uses Mappoint for her business. She ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    ZIP Code Export from Mappoint loses leading 0

    Any help that someone can give would be GREATLY appreciated.

    One of our clients uses Mappoint for her business. She imports a spreadsheet of Addresses (this works quite nicely) then plots them on her map with pushpins (this works just fine) ... she then defines a driving range (like everyone with a 30 minute radius) and Mappoint delivers just fine. She then clicks on the border of the driving range, selects "Export to Excel" and BAM! The leading zero's of the Zip Code are truncated, and being in NJ, all our Zip Codes begin with zero. The problem here is some of her addresses have the Zip +4, some don't. Is there a way to force Mappoint to export leading zero's to Excel? I already looked in Excel, no luck...

    Thanks in advance!

    Joe Palmer
    HKS Associates, Inc.

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    Can you just append the 0 back on in Excel? Do something like
    = Left("0000" & A1,5)
    and use the Len function and if needed the If function to test for the zip4's..

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Format the cells within excel to be zip-code type cells and the 0's come back

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to add postal code to territories for an excel export ?
    By nat in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-25-2005, 06:23 AM
  2. MPControl embedded in excel - excel loses functionality
    By ruyasan in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 05-20-2004, 03:41 AM
  3. Apptera Deploys Packaged Speech Application for Leading Bank
    By Eric Frost in forum News and Announcements
    Replies: 0
    Last Post: 03-17-2004, 11:27 PM
  4. Can I export a name list from mappoint
    By billholden in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-28-2003, 04:25 AM
  5. MapInfo Updates Industry Leading Enterprise Mapping Solution
    By Anonymous in forum News and Announcements
    Replies: 0
    Last Post: 08-28-2003, 10:54 AM

Tags for this Thread

Posting Permissions

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


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83