View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geoff E Geoff E is offline
external usenet poster
 
Posts: 8
Default Converting Integers to text

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