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: Friday, September 5, 2014 6:58 AM
Points: 52, Visits: 133
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:01 AM
Points: 3,645, Visits: 7,962
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.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

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