Excel Formula Help?

  • Thread starter Thread starter kacmatt
  • Start date Start date
K

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
 
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
 
There are many ways to do what you want to do. Here's one that comes to mind:
="0000"&ROW()&"-2010"
 
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.
Click to expand...
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
 
Back
Top