Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

Thanks

Evan

share|improve this question

2 Answers 2

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

 
discard

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.