It is Sequintial numbers line 8300-9100 needing all number inbetween

Does that mean you need:

8300-9100
8301-9100
8302-9100
8303-9100
...
...
9099-9100

If that's the case...

Assume you want these numbers starting in cell A1
Hit function key F5
In the Reference box, type A1:A800 (you need 800 sequential numbers
9100-8300 = 800)
OK

A1 will be the active cell
Type this formula but *do not hit ENTER* :

=8300+ROW()-1&"-9100"

After you type the formula hold down the CTRL key then hit ENTER
This will fill the cells with the numbers.
With the range of cells still selected
Goto the menu EditCopy
Then EditPaste SpecialValuesOK

That's it. You now have your sequential numbers.

--
Biff
Microsoft Excel MVP


"jblev" wrote in message
...
It is Sequintial numbers line 8300-9100 needing all number inbetween

"jblev" wrote:

I am trying to enter several hundred numbers in one colum. But would like
to
expel some of the time it will take to do so.. Is thier a quick way to do
this...