Powerful Outlook Add-ins

Service Support Forum for DS Development Add-ins and Utilities
It is currently Sun Nov 17, 2019 3:35 pm

All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Mon Sep 14, 2009 7:36 pm 
Offline

Joined: Mon Sep 14, 2009 7:12 pm
Posts: 2
Starting with an Excel file with the zip code field formatted as "text" when I import the file, I can see the zeros in a zip code like "04106" But after merging and then outputting the file, and opening the file up, the lead zero has been deleted. "04106" becomes "4106" I need to load this zip file into a zip-plotting map software, so re-formatting as "zip code" or "Zip code + 4" doesn't help. How can I keep my zip codes intact?



Top
 Profile  
Reply with quote  
PostPosted: Tue Sep 15, 2009 5:13 pm 
Offline
Site Admin
User avatar

Joined: Thu Mar 25, 2004 1:52 pm
Posts: 669
1. Try saving the file as a CSV file, then import it to Quicklist;
2. Where do you see the ZIP codes displayed without the leading "0"? In Quicklist or in Excel? If it's Excel and the file is CSV, can try opening it with Wordpad and see if the zeros are displayed correctly?



Top
 Profile  
Reply with quote  
PostPosted: Tue Sep 15, 2009 5:53 pm 
Offline

Joined: Mon Sep 14, 2009 7:12 pm
Posts: 2
Thanks for getting back to me. I've tried saving as a CSV and TXT file, and then importing. Same thing happens. I can see the leading zeros in Quicklist. It's when I export the file that they're truncated. In Excel or Word (opening the text file) the leading zeros just aren't there...my guess is because somehow in the export, the cell contents are being treated as numbers rather than text. Since "04106" isn't a number, it gets written as "4106." Any ideas?



Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group