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

Hi,

If '5/1, 5/2, 5/3' is in Cell A1 then in B1 enter
=ReverseCell(A2,TRUE).

You need to add the VBA code to the sheet first to work

http://www.ozgrid.com/VBA/ReverseCell.htm

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566800

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

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

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