The only way I can think of to do that is to set up the numbers in helping columns elsewhere in the workbook, probably in the same worksheet somewhere to the right.
Like this: In X1 and Y1 put the values 0 and 0.
In Y2 put =IF(Y1=39,0,Y1+1). Once you copy this formula down (as far as you like), it causes each value in Y to increment up to 39 and then start over at 0.
In X2 put =IF(Y2=0,X1+1,X1). When you copy this formula down, it causes X to stay the same until the value in Y has cycled back around to 0.
Now back in column A put =X1&"."&Y1&".00".
I haven't tested this code, but I hope it gives you the idea.
|