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.