Can anyone help me as i have never used excel before

[KODIAK BEAR]

I am new to windows excel and i am typing in column 'A' the following;

08 001
08 002
08 003
Now, rather than type this out 958 times downwards, is there a way of
getting it to fill automatically rather than typing it in please ?

I tried clicking the bottom left hand corner and scrolling down but all i
got was this;

08 001
09 001
10 001
and so on.

Can anyone tell me how to make it automatically put the next number in
please ?
Mind you, thats if it can be done ? Bearing in mind i am not computer
literate so please, no quantum physic type answers or my brain cell will
explode !

Thank you all for looking

 

[John]

try typing in "08 001 in the first cell, fill down using the fill handle on
the bottom right of the cell and fill series. Then use find & replace an
replace " leaving the replace cell blank and select replace all.

or

format the cell to the custom format "08" 000. put 1 in the first cell and
fill down then select fill series
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[KODIAK BEAR]

Hi John,
Thank you for replying.

Please forgive me here ok, bear with me.

1.What is a cell ?

2.Do i put " before i type 08 001 as you have put ?

3.How do i format please ?

as you can see, i am new to this.

Thank you for your help sir

 

[KODIAK BEAR]

John,

sorry, i am dancing around the room now.

ok, i did "08 001 and it worked.

Now all i have to do is work out how to get rid of " ?

Thank you mate.
made my day this has

 

[KODIAK BEAR]

Oh wow,

Ok, a very quick update john.

You sir are brilliant ! A super star.

Thank you

You will not belive how much time you have saved me sir.

I got the find and replace and it worked.

Thank you once again.

If you lived here the UK i would buy you a pint !

Kindest regards

andy

 

[Wondering]

I suggest you purchase Microsoft Office Excel 2007 (or whatever version you
have) Step by Step. By Curtis D. Frye. Published by Microsoft. $24.99 U.S.
Then follow that with Microsoft Office Excel 2007 (or whatever version you
have) Bible. By John Walkenbach. Published by Wiley Publishing Inc. $39.99
U.S.

 

[Theslaz]

I suggest you purchase Microsoft Office Excel 2007 (or whatever version you
have) Step by Step. By Curtis D. Frye. Published by Microsoft. $24.99 U.S.
Then follow that with Microsoft Office Excel 2007 (or whatever version you
have) Bible. By John Walkenbach. Published by Wiley Publishing Inc. $39.99
U.S.

What? Spend money! You must be daft!

 

[John]

Thanks for the feedback, I am glad it worked.

I do live in the UK so how about that pint then? - The Ice hockey team I
support should give you an indication of where I live

--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)