Thread: Numbering
View Single Post
  #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