How to generate a sequence of numbers in excel where the last number is constant?

[aksh]

For example,
How you generate the below automatically, without physically typing it out?

2.1.2.1.0
2.1.2.2.0
2.1.2.3.0
2.1.2.4.0
2.1.2.5.0
2.1.2.6.0
2.1.2.7.0
2.1.2.8.0
2.1.2.9.0
2.1.2.10.0
2.1.2.11.0
2.1.2.12.0
2.1.2.13.0
2.1.2.14.0

Thank you

 

[Marcelo Branco]

Try this

="2.1.2."&ROWS($1:1)&".0"

copy down

M.

 

[repairman615]

Do any of the other numbers change?



="2.1.2."&ROW(A1)&".0"

copied down.

 

[repairman615]

Food for thought... the above solutions display as text.



This custom number format:

"2.1.2.".0

should display as numbers if that is important.

Use as =row(A1) or =rows($1:1)

 

[aksh]

Try this

="2.1.2."&ROWS($1:1)&".0"

copy down

M.

Thank you Marcelo... It worked

 

[aksh]

Do any of the other numbers change?



="2.1.2."&ROW(A1)&".0"

copied down.

Thank you so much... It worked.
And no, the other numbers do not change

 

[repairman615]

Glad to help, welcome to the message board!