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