A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Numbering



 
 
Thread Tools Display Modes
  #1  
Old June 18th, 2009, 01:51 AM posted to microsoft.public.excel.worksheet.functions
kumar
external usenet poster
 
Posts: 45
Default 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
Ads
  #2  
Old June 18th, 2009, 01:59 AM posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
external usenet poster
 
Posts: 2,468
Default 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  
Old June 18th, 2009, 04:21 AM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default 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  
Old June 18th, 2009, 04:55 AM posted to microsoft.public.excel.worksheet.functions
Rich/rerat
external usenet poster
 
Posts: 423
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.