Hi all

this will probably be very simple for someone but i could do with knowing how to program an automated number sequence

I have a quote log and the numbers we generate are like this ECQ123/12

This all means something to us - ECQ = electronic inquiry - 123 - the quote number and the /12 means 2012 - as we archive all of the quotes

I would like excel to generate the sequence in the log as follows in a column

ECQ123/12
ECQ124/12
ECQ125/12
ECQ126/12

how do i do this ?
please help as will be making our lives easier if the quote number generates itself

cheers
James