consectutive numbers

[Bob Smith]

what program will allow me to enter a start number, like
0001, and an end number, like 10,000 and fill in all
numbers in between and the kicker is, HOW? thanks

bob smith

 

[Mike Williams [MVP]]

what program will allow me to enter a start number, like
0001, and an end number, like 10,000 and fill in all
numbers in between and the kicker is, HOW? thanks

Excel has several means, including Data Fill.

--

Mike Williams - Office MVP
http://www.mvps.org/

Please respond in the same thread on this newsgroup. Make sure you
include details of your application and Windows versions, plus any
service pack updates.

Do not mail to me directly without invitation - you have a choice of
getting ignored or billed for my time. Most questions can be answered
by reading recent NG posts, checking the MVPS web FAQs or searching the
relevant Google archive e.g.
http://groups.google.com/groups?group=microsoft.public.word.spelling.grammar

 

[SA]

Bob:

Easy to do in Excel. Simply start numbering cells 1, 2, 3, 4, 5, etc. in a
column. Select the cells and then use the fill handle (fill handle: The
small black square in the lower-right corner of the selection. When you
point to the fill handle, the pointer changes to a black cross.) to drag
down as many rows as you want to fill with a continuation of the series.

Steve Arbaugh

 

[Bob Smith]

thank you for that quick reply. perhaps i did not make
myself clear. is there a way to enter a start number & an
end number & have the program fill in the in between
numbers?

bob smith

 

[David]

Bob

What program?

It is a trivial matter to write a program (in C, or any other inferior
language) to do this, but where do you want the output? Are you trying to
do it in Word, or Excel, or where?

David