how do i enter numbers from 42.33 - 50.00 using a formula rather than typing
all the numbers?

In what logical order?

By 1/100ths like 42.33, 42.34, 42.35

Enter 42.33 in A1

Enter 42.34 in A2

Select A1 then type A1:A768 in the namebox.

Hit Enter then EditFillSeriesAutofill


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 21:27:01 -0800, macca
wrote:

how do i enter numbers from 42.33 - 50.00 using a formula rather than typing
all the numbers?

yes by 1/100's. but i want it to go from a to p on each line (this is so it
all prints on the one page) is this possible? also what is the namebox?

"Gord Dibben" wrote:

In what logical order?

By 1/100ths like 42.33, 42.34, 42.35

Enter 42.33 in A1

Enter 42.34 in A2

Select A1 then type A1:A768 in the namebox.

Hit Enter then EditFillSeriesAutofill


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 21:27:01 -0800, macca
wrote:

how do i enter numbers from 42.33 - 50.00 using a formula rather than typing
all the numbers?

As far as your second question is concerned, what did it tell you when you
typed namebox into Excel help?

For the first question, it might have been better if you'd given the full
details when you first asked the question.
Put 42.33 into A1, then in B1 put =A1+0.01 and copy across C1 to P1.
In A2 put =P1+0.01. Copy B1:P1 down to B2:P2. Copy A2:P2 down as far as
necessary.
--
David Biddulph

"macca" wrote in message
...
yes by 1/100's. but i want it to go from a to p on each line (this is so
it
all prints on the one page) is this possible? also what is the namebox?

"Gord Dibben" wrote:

In what logical order?

By 1/100ths like 42.33, 42.34, 42.35

Enter 42.33 in A1

Enter 42.34 in A2

Select A1 then type A1:A768 in the namebox.

Hit Enter then EditFillSeriesAutofill


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 21:27:01 -0800, macca

wrote:

how do i enter numbers from 42.33 - 50.00 using a formula rather than
typing
all the numbers?