Excell question

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Ok being a fool here but i cannot remember for the life of me how to do this.

Entering data into excel and i want to have a column down the left with an incrementing reference code.
What im after is AA-AAAA-0000 with only the number incrementing each time.

Anyone have any thoughts?

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Enter the AA-AAAA-0000 into the cell. Select the cell, and then hold the ctrl and hover over the bottom right corner of the selected cell. You'll see a tiny + appear, click on the corner and drag down. When you let go you'll see the incremented number.

 

ManicMonkey,

Off the top of my head...

A1=[Heading title]
A2="AA-AAAA-"
B2=0000
A3="AA-AAAA-"
B3=B2+1

Then grab the solid square bottom right corner of cell B3 then drag it down until you've got enough numbers.

Will this work for you?

 

Just got told the really silly simple answer

AA-AAAA-0000 in cell 1
AA-AAAA-0001 in cell 2

select both cells and then drag using the corner of the box, excell works out th difference between teh two and then increments.
DOH!


Cheers for the answers though peeps