Mix text and numbers with leading zeros
 

Good morning,
Trying to create barcodes by putting text (W0410) plus 08, plus a five digit
number beginning with 000001 and incrementing by 1. The leading zeros should
display. The result of the first cell should be W0410 08 000001. The result
of the second cell should be W0410 08 000002. I will need 1,000 so the last
cell should be W0410 08 001000
Formula so far is
=AZCode&" 08 "&CodeStart with AZCode=W0410 and CodeStart being 000000. I
don't know how to increment it and how to not loose the leading zeros.
Thank you,
Susan

Mix text and numbers with leading zeros
 

=AZCode&" 08 "&TEXT(ROW(),"000000")
--
David Biddulph

"Susan B" wrote in message
...
Good morning,
Trying to create barcodes by putting text (W0410) plus 08, plus a five
digit
number beginning with 000001 and incrementing by 1. The leading zeros
should
display. The result of the first cell should be W0410 08 000001. The
result
of the second cell should be W0410 08 000002. I will need 1,000 so the
last
cell should be W0410 08 001000
Formula so far is
=AZCode&" 08 "&CodeStart with AZCode=W0410 and CodeStart being 000000. I
don't know how to increment it and how to not loose the leading zeros.
Thank you,
Susan

Mix text and numbers with leading zeros
 

="W0410 08 "&TEXT(ROWS($1:1),"000000")

copy down as far as needed



"Susan B" wrote:

Good morning,
Trying to create barcodes by putting text (W0410) plus 08, plus a five digit
number beginning with 000001 and incrementing by 1. The leading zeros should
display. The result of the first cell should be W0410 08 000001. The result
of the second cell should be W0410 08 000002. I will need 1,000 so the last
cell should be W0410 08 001000
Formula so far is
=AZCode&" 08 "&CodeStart with AZCode=W0410 and CodeStart being 000000. I
don't know how to increment it and how to not loose the leading zeros.
Thank you,
Susan

Mix text and numbers with leading zeros
 

They both work wonderfully (I actually used a combination of each).

Thank you so much.

Susan

"Teethless mama" wrote:

="W0410 08 "&TEXT(ROWS($1:1),"000000")

copy down as far as needed



"Susan B" wrote:

Good morning,
Trying to create barcodes by putting text (W0410) plus 08, plus a five digit
number beginning with 000001 and incrementing by 1. The leading zeros should
display. The result of the first cell should be W0410 08 000001. The result
of the second cell should be W0410 08 000002. I will need 1,000 so the last
cell should be W0410 08 001000
Formula so far is
=AZCode&" 08 "&CodeStart with AZCode=W0410 and CodeStart being 000000. I
don't know how to increment it and how to not loose the leading zeros.
Thank you,
Susan