In my file I have a column with zipcodes. Some times the zipcodes are only 4 digits because the 0 in front was dropped. Is there code I can put in that would add the leading zero wehn it is four digits and format the column to text?
In my file I have a column with zipcodes. Some times the zipcodes are only 4 digits because the 0 in front was dropped. Is there code I can put in that would add the leading zero wehn it is four digits and format the column to text?
Assuming your zips are in Column A and that you will run the code after selecting the sheet to modify:
![]()
Please Login or Register to view this content.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
Hi davidsons,
There is a custom format of zip codes in most versions of excel.
Or see if any of these links help.
http://office.microsoft.com/en-us/ex...010274823.aspx
http://excel.tips.net/T002793_Sorting_ZIP_Codes.html
http://www.ofzenandcomputing.com/zanswers/3552/
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I couldn't get it to work and tried to modify the code, but it is still not working. Any suggestions?
![]()
Please Login or Register to view this content.
Last edited by davidsons; 04-28-2011 at 01:05 PM.
Can you attach a sample of your workbook?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks