Makes sense, although Comma Style worked for me.

Regards,

Hutch

"Gord Dibben" wrote:

Tom

Maybe Comma style should be Fraction from FormatCellsNumber


Gord Dibben MS Excel MVP

On Mon, 31 Jul 2006 13:42:02 -0700, Tom Hutchins
wrote:

Format your starting cell as Comma Style and enter 1/5. It should display 1/5
in the cell and 0.2 in the Formula bar. Select Edit Fill Series. Select
data in Columns, Step Value = .2, Stop Value = the final value you want in
the series, and click OK.

Hope this helps,

Hutch

"Earl" wrote:

I would like to auto fill plan sheets numbered '1/5, 2/5, 3/5' etc.

Reversing the order to '5/1, 5/2, 5/3' etc. works but I want to keep them
in their original order if possible.

Is there a way?
TIA