I have the need to merge a bunch of cells that comprise an address (street, city, state, zip) into a single cell. No problem except with the zip code.

The zip cell has only 4 digits for any zip that starts with 0. So, I change it's format to be Special -> Zip Code. That makes the cell itself show the beginning 0, but the merged cell still does not show the leading 0.

Does anyone know how to get the leading 0 in the merged column?




If you have the Zip code in cell A1 you can use the formula =TEXT(A1, "00000") to format the Zip code as 5 digits wide with leading zeros and then merge that instead of the numeric version.


See this question

MS Word 2007 Mail Merge fails on ZIP codes with leading Zeros (eg. 01234)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.