Excel Formula Help?
 

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

Excel Formula Help?
 

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

Excel Formula Help?
 

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

--
Biff
Microsoft Excel MVP


"kacmatt" wrote in message
...
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

Excel Formula Help?
 

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

Matt

"Mike H" wrote:

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

Excel Formula Help?
 

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


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Mike H" wrote:

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

Excel Formula Help?
 

Glad I could help

"kacmatt" wrote:

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

Matt

"Mike H" wrote:

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

Excel Formula Help?
 

On Jan 3, 7:39�pm, 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.

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

Excel Formula Help?
 

That's OK, Ryan, if after 00009-2010 you want to go to 000010-2010, and then
after 000099-2010 you want to go to 0000100-2010, but it's probably more
likely that the OP wanted 00010-2010 and 00100-2010.
--
David Biddulph

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

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

"Mike H" wrote:

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