Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Excel Marco - Replacing leading zero for Zip Code Expand / Collapse
Author
Message
Posted Friday, May 31, 2013 2:06 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 8:33 AM
Points: 50, Visits: 129
Hi,

I am looking for help to understand how to create an Excel Macro that will update all records in a column that have less than 5 digits with a leading zero. I have found a way to make this work by Cell but cannot get it to work by updating all records in a column.
Post #1458869
Posted Friday, May 31, 2013 3:04 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:51 PM
Points: 3,354, Visits: 7,251
Not really the right forum to ask, but there's a format option for zip codes in the special category. Otherwise, you can use the personalized format and enter five zeros (00000).


Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1458885
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse