Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
numbering | Excel Discussion (Misc queries) | |||
numbering | Excel Discussion (Misc queries) | |||
numbering | Excel Discussion (Misc queries) | |||
Numbering | Excel Worksheet Functions |