Next number in sequence

Adobe Dreamweaver cs5
May 3, 2011 at 07:57:23
Specs: Windows XP, 2GB RAM
Hi all - I have sequential numbers going down a column such as 1001, 1002 etc - the normall formula would be =C3+1 then gives me 1003 BUT how do I manage this if I am dealing with Policy numbers such as TYN1001, TYN1002 etc please?

Thanks in advance :)

I only pretend to know what I'm talking about.


See More: Next number in sequence

Report •

#1
May 3, 2011 at 09:17:23
Click a cell and hold your cursor over the black square in the lower right corner.

When it turns into a plus sign, click the box and drag down.

Excel will autofill the cells, incrementing your Policy numbers by 1.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
May 3, 2011 at 09:34:22
BRILLIANT!! thank you SO much, how wonderful :o)

I only pretend to know what I'm talking about.


Report •
Related Solutions


Ask Question