Bernie,

You're Awesome!!!
That was sooooo fast too!!

Thank You!!!!

David

"Bernie Deitrick" wrote:

Demccaff,

="611-a1-a"&TEXT(ROW()-4,"000")&"-a"

HTH,
Bernie
MS Excel MVP


"Demccaff" wrote in message
...
Howard,

Thank you! This is a great tool! Is there a way to accomplish this:

611-a1-a001-a; 611-a1-a002-a; 611-a1-a003-a; . . . 611-a1-a125-a, etc

I used your example to create this ="611-a1-a"&ROW()-4&"-a"

where I'm subtracting 4 from the row, as the series starts on row 5. But
the part I cannot get to work is the leading "0"s. Is there a way to have
two or one leading zero for a constant 3 characters?
Any help would be much appreciated.

Thank you,
David

"L. Howard Kittle" wrote:

Hi JMart,

try this.

="ME-0"&ROW()-1&-"10"

and pull down.
HTH
Regards,
Howard


"JMart" wrote in message
...
I have a question similar to this one. I'm trying to continue a series in
this way: ME-000-10, ME-001-10, ME-002-10, etc., but am stumped as to
how-thanks for any ideas!

"Ron Coderre" wrote:

If it's just for appearance...

Perhaps this:
Starter cell: 2566

From the Excel Main Menu:
<format<cells<number tab
Category: Custom
Type: 0000-1
Click [OK]

(the cell will now display as: 2566-1)

Then, click an hold on the cell's fill handle
(small black box in the lower right)
and drag down while holding down the [CTRL] key.

The end result will look like this:
2566-1
2567-1
2568-1
2569-1
2570-1
etc

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"cyndi" wrote in message
...
Hi I am using Excel 2003, Here's the problem, I need to fill a series
keeping
the last number constant: For Example
2566-1
2567-1
2568-1
2569-1
2570-1
Etc.

But I get this instead when I try to autofill it
2566-1
2567-1
2568-1
2566-2
2567-2
2568-2
Is there a way to keep the last number consitant? Any Help would be
awesome. Thanks