Leading zero's in text join

if it is formatted as text, it should not strip off the
leading 0.

-----Original Message-----
I have 4 colums a,b,c,d

I use A1&" "&B1&", "&C1 in colum d to combine the text
into one cell. (city,
state and zip) My problem is that colum c is the zip code
cell and it's
formatted that way, when it combines to colum d it strips
the leading zero
off the zips. is there a way to format the ' apostrophe
in and where?

thanks

ray pistey


.