Fill series based on a function ?

[GBall]

Hi,
I want to fill a series of task numbers prefixed by a version number which is held in a cell and will change with each release (I'm trying to create a boilerplate spreadsheet for future releases).
So I have 1.7 in a cell and I want to fill a series with
1.7.1, 1.7.2 etc.
Excel (95 !!) doesn't want to play.
I have =$g$1 & "." & 1 in the cell.
I have tried moving it to another cell and just referencing that - =$g$3 and putting =$g$1 & "." & 2 in the following cell, in the hope that it would catch on.
Thanks for any help.

Regards,
Graham

 

[ETID]

If 1.7.1 is in cell a1, then type this in a2 and fill down...

=LEFT(A1,4)&RIGHT(A1,1)+1




Also if your version of excel has the little tag on the bottom right corner of the selected cell box, then you need only highlite a1 and grab that tag and drag down....

 

[GBall]

That's great, thanks.
Is it possible to fill a range a1.... from a start point of say g1 holding the release number.
Also, is it possible to 'poke' an actual value into a cell rather than the reference/function ?
What I mean is could a function in one cell populate another cell with an actual value?

Regards,
Graham

 

[GBall]

Worked out how to do that, but that example doesn't work beyond 10.
I don't think Excel 95 has enough functions available to get really clever there tho', but I'm looking.

Regards,
Graham

 

[GBall]

Cracked it for anyone else daft enough to want this B-)

1.7 is the new release in G1
Top of the fill series in B4 looks like
=$G$1 & ".100"
Second row in B5 looks like
=LEFT(B4,(LEN(B4)-(LEN(B4) - FIND(".",B4,3))))&RIGHT(B4,LEN(B4) - FIND(".",B4,3))+100

Gives 1.7.100 to 1.7.1000 and beyond.

thanks ETID for kicking me off in the right direction Regards,
Graham