Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?



share|improve this question

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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