formula question
 

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

formula question
 

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?

formula question
 

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?

formula question
 

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?