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