Leading zero's in text join

[Trevor Shuttleworth]

Raymond

something like:

=A1&" "&B1&", "&TEXT(C1,"0000000")

Not sure how many zeroes you need; adjust to taste.

Regards

Trevor

 

[Frank Kabel]

Hi
if your zip code has 5 digits try
=A1 & " " & B1 & ", " & TEXT(C1,"00000")

 

[Arvi Laanemets]

Hi

Try something like
=A1&" "&B1&" "&TEXT(C1,"0000000000")

 

[Harald Staff]

Hi Ray

Crossposting from a pre-dated computer is not nice. Simple stuff like this
is easily solved in a single newsgroup. Now we have to watch this thread on
top of our newsreaders in all groups the next two days, or spend lots of
time removing it, each one of us. Don't do it again please.

Best wishes Harald

 

[Robert McCurdy]

Ray, how did you get Time Travel?

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

 

[Don Guillett]

Harald, I just delete as this is very often NOT by mistake.

 

[Raymond Pistey Jr]

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