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
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 21, 2014 1:20 PM
Points: 47, Visits: 126
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:16 PM
Points: 2,763, Visits: 5,915
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