Numbering

K

Kumar

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.
 
J

JE McGimpsey

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.
 
J

Jacob Skaria

Try the below formula in Row 1 and copy this down as needed. The numbering is
as per the row. Once done copy the numbers>PasteSpecial>Values...

="CMD/BCN/AMD/" & TEXT(ROW(),"000")

If this post helps click Yes
 
R

Rich/rerat

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>>


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top