Leading zero's in text join

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

--
Regards
Frank Kabel
Frankfurt, Germany


Raymond Pistey Jr wrote:
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

Hi

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


--
(Don't use my reply address - it's spam-trap)

Arvi Laanemets


"Raymond Pistey Jr" wrote in 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

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

Ray, how did you get Time Travel?


"Raymond Pistey Jr" wrote in 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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.631 / Virus Database: 404 - Release Date: 17/03/2004

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

--
Don Guillett
SalesAid Software

"Harald Staff" wrote in message
...
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