Auto fill decimal sequence using custom fill or formula

Hi,

I am trying to use auto fill to do a sequence like this instead of having to type many rows of something that is very repetitious:

ZCT150 5.0
ZCT150 5.5
ZCT150 6.0
ZCT150 6.5
ZCT150 7.0
ZCT150 7.5

ETC.

I tried a custom fill, but that does not do what I expected. It just does the same as the auto fill.

I'm thinking maybe a formula will do it, but I'm not sure how to build such a formula.

Any help is greatly appreciated!

Sorry, I did mess up! The ZCT150 will change also.

ZCT150 5.0
ZCT155 5.5
ZCT160 6.0
ZCT165 6.5
ZCT170 7.0
ZCT175 7.5

Originally Posted by XOR LX

Perhaps:

="ZCT"&145+5*ROWS($1:1)&TEXT(4.5+ROWS($1:1)/2," 0.0")

and copy down.

Regards

Thank you so much! I used this one first and it worked great. We are just having a formatting problem with the Excel spreadsheet that I need to address. It works fine in a general format, but the spreadsheet that the person I am helping is using is a text format. I have had this problem before and should be able to work it out.

Thanks again!