If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Numbering
Hi there.
I would like to inquire on how to create formula for sequential numbering for examples given below: 1. CMD/BCN/AMD/001 2. CMD/BCN/AMD/002 3. CMD/BCN/AMD/003 4. CMD/BCN/AMD/004 I need to make the first few characters fixed but change the number at the end. I need formula for this as i want to change the numbering at the end to diff no by just changing hte formula. Thanks a lot. -- Kumar |
#2
|
|||
|
|||
Numbering
One way:
If you just want that to display: A1: 1 A2: =A1 + 1 Copy A2 down. Select Column A. Choose Format/Cells/Number/Custom and use "CMD/BCN/AND/"000 as your format. In article , Kumar wrote: Hi there. I would like to inquire on how to create formula for sequential numbering for examples given below: 1. CMD/BCN/AMD/001 2. CMD/BCN/AMD/002 3. CMD/BCN/AMD/003 4. CMD/BCN/AMD/004 I need to make the first few characters fixed but change the number at the end. I need formula for this as i want to change the numbering at the end to diff no by just changing hte formula. Thanks a lot. |
#3
|
|||
|
|||
Numbering
Try the below formula in Row 1 and copy this down as needed. The numbering is
as per the row. Once done copy the numbersPasteSpecialValues... ="CMD/BCN/AMD/" & TEXT(ROW(),"000") If this post helps click Yes --------------- Jacob Skaria "Kumar" wrote: Hi there. I would like to inquire on how to create formula for sequential numbering for examples given below: 1. CMD/BCN/AMD/001 2. CMD/BCN/AMD/002 3. CMD/BCN/AMD/003 4. CMD/BCN/AMD/004 I need to make the first few characters fixed but change the number at the end. I need formula for this as i want to change the numbering at the end to diff no by just changing hte formula. Thanks a lot. -- Kumar |
#4
|
|||
|
|||
Numbering
Kumar,
If you put CMD/BCN/AMD/001 in a cell, and pull down the column, by the bottom right hand corner (+ sign) of the cell, it will increase the numerical section of the item. As long as the number section is to the far right, it will increase by one as you drag down the column. A12/b34 will fill in as: A12/b35 A12/b36 A12/b37 Not: A13/b35 A13/b36 A13/b37 JE, There is a potential problem with formatting an excel cell as you have it, if you want to use this data in a Mail Merge. The formatting in Excel will not transfer to Word's mail merge. You would have to manually construct the item# like this, in the Mail Merge Document. If there is a large list of items, this could be a problem CMD/BCN/AMD/{Mergefield "Item" \# "000"} -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "JE McGimpsey" wrote in message ... One way: If you just want that to display: A1: 1 A2: =A1 + 1 Copy A2 down. Select Column A. Choose Format/Cells/Number/Custom and use "CMD/BCN/AND/"000 as your format. In article , Kumar wrote: Hi there. I would like to inquire on how to create formula for sequential numbering for examples given below: 1. CMD/BCN/AMD/001 2. CMD/BCN/AMD/002 3. CMD/BCN/AMD/003 4. CMD/BCN/AMD/004 I need to make the first few characters fixed but change the number at the end. I need formula for this as i want to change the numbering at the end to diff no by just changing hte formula. Thanks a lot. |
Thread Tools | |
Display Modes | |
|
|