G
Guest
how do i enter numbers from 42.33 - 50.00 using a formula rather than typing
all the numbers?
all the numbers?
G
Gord Dibben
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 Edit>Fill>Series>Autofill
Gord Dibben MS Excel MVP
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 Edit>Fill>Series>Autofill
Gord Dibben MS Excel MVP
G
Guest
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?
all prints on the one page) is this possible? also what is the namebox?
D
David Biddulph
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
1 down to B22. Copy A22 down as far as
necessary.
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
1 down to B22. Copy A22 down as far asnecessary.