Converting Integers to text

G

Geoff E

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><title>pic" & i & "</title>"
To this:
Print #1, "<html><title>pic" & TEXT(i,"00") & "</title>"
does not work because the "TEXT" function is not a VBA function.

Any suggestions greatly appreciated.

Geoff
 
S

smartin

Geoff said:
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><title>pic" & i & "</title>"
To this:
Print #1, "<html><title>pic" & TEXT(i,"00") & "</title>"
does not work because the "TEXT" function is not a VBA function.

Any suggestions greatly appreciated.

Geoff
Click to expand...

In VBA use Format(i,"00")
 
S

smartin

YW. Funny thing is, I often find myself trying to use Format() as a
worksheet function. Doesn't work (^:
 
Top