Excel Marco - Replacing leading zero for Zip Code

  • 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.

  • 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.
    General Disclaimer:
    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?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply