automatic numbering-how to use automatic numbering.

Hi, I would really appreciate if somebody can teach me how to use automatic numbering.

I'm using Microsoft Excel 2003 and I'd like to make a list of numbers starting from 0, 0.02, 0.04, 0.06, .....,15.00. When I try making the list using reference from Excel help, the numbers become 1.02, 2.02, 3.02, .......

Thank you.

Hi,

Probably easiest to type in your first two values

eg

0.02
0.04

Highlight both cells and then drag the fill handle down.

hth

Dave

Originally Posted by gjoy993

Hi, I would really appreciate if somebody can teach me how to use automatic numbering.

I'm using Microsoft Excel 2003 and I'd like to make a list of numbers starting from 0, 0.02, 0.04, 0.06, .....,15.00. When I try making the list using reference from Excel help, the numbers become 1.02, 2.02, 3.02, .......

Thank you.

Hi Gjoy

You write 0,02 in A1 for example.Select after the range A1:A20.Then, openEdit/Fill/Series and choose the step 0,02.

Thanks a lot!

You're welcome. Thank you for the feedback.