problem with zip codes

**mccormij** · 02-21-2009, 08:09 PM

I have a list of wedding addresses in an excel worksheet and I am using the mail merge feature in word to create a bunch of address labels. Some of the addresses have zip codes that begin with a "0" such as "03413".

For some reason the zip appears correctly in the cell as "03431" but in the formula bar it appears as "3431" so I can tell that excel in removing the "0". As a result, when I go to print an address label I get "3431" in the zip field.

I've tried changing the format to "zip codes" and everything else but the "0" is always missing in the formula bar no matter which format I use.

If anyone can figure this out please let me know

**shg** · 02-21-2009, 08:35 PM

You need to format the cells as text, and then restore the leading zeros.

**mccormij** · 02-21-2009, 09:22 PM

thanks that worked great!!!

I didn't realize that I needed to go back in and add the 0 after selecting the text format

**Sanghvi** · 02-21-2009, 09:37 PM

Type ' (Apostrophe) before entering the zip code. Excel will then accept it as a text, and will print the number preceeded with a zero. You will have to realign the cell as required.

Sanghvi