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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find text in between to knowns 2
Update this macro to make it generate a counter as text 7
Help With Input Box 3
Converting HTML to Plain Text 4
Befuddled by layout for text, text box and pics--Word 2007 9
I need some calculations done in a message text string ... 3
Boiler Plateing text into another text document. 9
Converting a string to an array of integers 4

Top