Excel Formula Help?

[kacmatt]

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

 

[Mike H]

Hi,

Put this in your cell and drag down

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

Mike

 

[T. Valko]

Try this...

Assume you want to start this sequence in cell A1.

Enter this formula in A1 and copy down as needed:

=TEXT(ROWS(A$1:A1),"00000-")&2010

 

[kacmatt]

Worked like a CHARM Mike! Thank you very much!!!!!

Matt

 

[ryguy7272]

There are many ways to do what you want to do. Here's one that comes to mind:
="0000"&ROW()&"-2010"

 

[Mike H]

Glad I could help

Worked like a CHARM Mike! Thank you very much!!!!!

Matt

 

[alanglloyd]

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.

Put 1 in the first cell, & 2 in the one below that.
Then select the first & next cell down.
Then drag the small square at the bottom right of the selection down
all the rows you want.
You will have a column filled with consecutive numbers from 1.
Select the whole set of numbers, Right click in the selection & choose
Format Cells and the Numbers tab
Click on Custom from the list.
Enter 0000"-2010" in the Type: edit box.
It will display the numbers as you wish

Alan Lloyd