Converting Integers to text
Geoff E wrote:
I am having trouble converting an integer to text. I need to place a
leading zero next to the number when it is less than 10.
Trying to change this:
Print #1, "<html<titlepic" & i & "</title"
To this:
Print #1, "<html<titlepic" & TEXT(i,"00") & "</title"
does not work because the "TEXT" function is not a VBA function.
Any suggestions greatly appreciated.
Geoff
In VBA use Format(i,"00")
|