Macro to convert zip code +4 format to text format

[narendrabr]

Hi ,

I need to convert cells having zip code + 4 format to text format because I am not able to see leading zeros and dash in the cell but visually it appears.I am using excel 2010.
Any help would greately appreciated.
Thanks

[Debraj Roy]

Hi Narendra..

Some of Forum member are not from USA, or even not idea.. what is "zip code + 4" format looks like..
however, If they can able to see some of the format or sample file with expected output, may be some Non-USA will also give a try..

[MarvinP]

Have you seen the Cell Format made for Zip Codes + 4? Read:
http://www.dummies.com/how-to/conten...r-formats.html

[narendrabr]

Hi,
Actually I have a column of zip code for that we need to append leading zeros to make 5 character lengh for those which are >3 character length and <5 character length and highlihght the value which is less than 3 character and also convert the cells into text format for importing purpose.
I am using this code but it is loosing dash and leading zeros which are already have 5 character length.
For example
The below code will provide the output
27773239 but visually I can see as 02777-3239

Please Login or Register  to view this content.

[martindwilson]

so what was wrong with the functions in your other thread?

[narendrabr]

Actually the code is not retaing leading zeros and dash and it is just converting the cells as text using this code
rng.NumberFormat = "@"

Thanks

[narendrabr]

Hi,
The above code is working fine if the cell is already text data type but if it is in zipcode+4 format it is not displaying leading 0 and dash.

Thanks!