I would never have thought of that! Thanks. SImple but effective.
--


Many thanks
JD


"Ron Coderre" wrote:

> Try this:
>
> Put your start value in the first cell
> Select the range to be filled
>
> <edit><fill><series>
> Step Value: 0.5
> Click the [OK] button
>
> With the range still selected......
> <edit><replace>
> Find What: *.5
> Replace with: (leave this blank)
> Click the [Replace All] button
>
> Is that something you can work with?
> ***********
> Regards,
> Ron
>
> XL2002, WinXP
>
>
> "Jackie D" wrote:
>
> > I'm using Office 2003 with XP Home.
> >
> > I like the function in excel to generate numbers in a series. This is
> > achieved by selecting a an unbroken series of cells first and then going to
> > Edit/Fill/Series.
> >
> > What I would like to do now is place the series of numbers in alternate
> > cells. Is this achievable? If it is, how do I select alternate cells? I can't
> > figure out a way to do it.
> >
> >
> > Many thanks
> > JD