Hi,

Put this in your cell and drag down

=TEXT(ROW(A1),"0000")&-YEAR(NOW())

Mike

"kacmatt" wrote:

Ok, I'm not all that familiar with Excel or it's formulas/functions.

Let me say thanks in advance for the responses.

Here's the situation:

I have a spreadsheet that has one column, the numbers need to increase like
below:

00001-2010
00002-2010
00003-2010

This is where the first number, must increase and the second number is the
year. The dash is always interpreted as a subtraction symbol.

Is there anyway I can create a formula to automatically increase the first
portion of the number, leaving the last part as is.

Thanks again,

Matt