| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leading Zeros and Phone numbers | Excel Worksheet Functions | |||
| Sort "text" numbers with and without leading zeros as numbers | Excel Discussion (Misc queries) | |||
| How do you delete leading zeros from numbers? | Excel Discussion (Misc queries) | |||
| sort numbers leading zeros | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Linear Mode
