Series formula needed

[pseadrift]

Hi All,
I am attempting to use a formula to create a repeating series that increments the whole number by one when the series is complete. For example, 1.01, 1.02, 1.03, 1.04, 2.01, 2.02, 2.03, 2.04, 3.01, etc.

I am using this formula but it does not give me two decimal places. It gives me this: 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 3.1, etc.

=CEILING(ROWS(A$1:A1)/4,1)&"."&MOD(ROWS(A$1:A1)-1,4)+1

Any suggestions?

Thank you in advance!

 

[BrianJN1]

Consider adding a '0' to your formula after the ".":
=CEILING(ROWS(A$1:A1)/4,1)&".0"&MOD(ROWS(A$1:A1)-1,4)+1

I haven't tried to assess your calculations but that appears to work.

 

[pseadrift]

Consider adding a '0' to your formula after the ".":
=CEILING(ROWS(A$1:A1)/4,1)&".0"&MOD(ROWS(A$1:A1)-1,4)+1

I haven't tried to assess your calculations but that appears to work.

I was so close. LOL Works like a charm! That is AWESOME! Thank you sooo much BrianJN1!