ClassCreator.com | Blockbuster sites, amazing reunions

Share Tips

New Topic Subscription Options  

download class list to Excel - zip code format error

Forums: Suggestions and Feedback
Created on: 02/20/12 08:25 PM Views: 1492 Replies: 2
Monday, February 20, 2012 at 8:25 PM

When I download the class list to the Excel format, the zip code column is not formatted correctly to account for leading zeros. Looks like it is downloading to "general" format.

A manual adjustment is required before using the file to create snail mail labels - which is really easy to forget!

I am using Excel 2007.

Thanks for a user friendly product.... is has been a blast exploring the features.

Reply
Tuesday, February 21, 2012 at 10:20 AM - Response #1

We'll take a look. This may be more dependent on the version and settings of your own installation of Excel, but we'll see if there's anything that can be done on our end.


Reply
Tuesday, February 21, 2012 at 10:36 PM - Response #2

Just go to the column that has the downloaded zip code information in Excel and format it as zip code. This results in the leading zeroes being added. Works in Excel 2003. I presume it will in 2007 also.

Reply
New Topic  
Subscription Options: Have all new forum posts sent directly to your email.
Subscription options are available after you log in.