MapForums
Community of VE/MapPoint Users and Developers
ZIP Code Export from Mappoint loses leading 0
This is a discussion on ZIP Code Export from Mappoint loses leading 0 within the MapPoint 2006/2009 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 ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-21-2003
| |||
| |||
| ZIP Code Export from Mappoint loses leading 0 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.         |
|
05-21-2003
| ||||
| ||||
|
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
__________________ |
 |
| Tags |
| code, export, leading, loses, mappoint, zip |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to add postal code to territories for an excel export ? | nat | MapPoint 2006/2009 Discussion | 3 | 05-25-2005 06:23 AM |
| MPControl embedded in excel - excel loses functionality | ruyasan | MapPoint 2006/2009 Discussion | 2 | 05-20-2004 03:41 AM |
| Apptera Deploys Packaged Speech Application for Leading Bank | Eric Frost | News and Announcements | 0 | 03-17-2004 11:27 PM |
| Can I export a name list from mappoint | billholden | MapPoint 2006/2009 Discussion | 1 | 10-28-2003 04:25 AM |
| MapInfo Updates Industry Leading Enterprise Mapping Solution | Anonymous | News and Announcements | 0 | 08-28-2003 10:54 AM |
All times are GMT -5. The time now is 10:12 AM.
