Format Cells?

  • Thread starter Thread starter @Homeonthecouch
  • Start date Start date
@

@Homeonthecouch

Hello,
Not sure if this is the easiest way to do this but I am wanting to create a series of cells
A1 10.0.0
A2 10.0.1
A3 10.0.2
Etc.
A14 10.0.15
A15 10.1.0
A16 10.1.1
A17 10.1.2
Etc.

Is there an easy method of doing this perhaps with a Format function or will I have to create a sum to work out the
last cell plus .0.1?

Any help is appreciated.


Andrew.
 
Give this a try in any starting cell, eg in A1:
=10&"."&INT((ROWS($1:1)-1)/16)&"."&MOD(ROWS($1:1)-1,16)
Copy down
 
Just to piggy back on Max's response.

You may want to end up with values that look like:

10.00.00
10.00.01
10.00.02
10.00.03
10.00.04
10.00.05
10.00.06

(You may find sorting your data much easier with this format.)

You could a minor modification to Max's formula to get it:
=10&"."&TEXT(INT((ROWS($1:1)-1)/16),"00")&"."&TEXT(MOD(ROWS($1:1)-1,16),"00")
 
Back
Top