Adobe Dreamweaver cs5

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.

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.

BRILLIANT!! thank you SO much, how wonderful :o) I only pretend to know what I'm talking about.

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History