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?