Convert integer to two digit string

[Curben]

I am trying to write a loop to update files ther are numbered 1-36 but for consistency the file name always has 2 digits

filename06.xlsb
filename22.xlsb

how do i convert the integer that increments from 1-36 to the two digit string for use in the filename refernece?

 

[Gary's Student]

How about:

Sub marine()
s1 = "filename"
s2 = ".xlsb"
For i = 1 To 36
    Cells(i, 1).Value = s1 & Format(i, "00") & s2
Next
End Sub

 

[Curben]

Most of that is not applicable but the syntax of format is exactly what i was trying to remember, thanks bunches

 

[Gary's Student]

You are very welcome!