VBA - numeric to text

[KG Old Wolf]

This must be simple but it eludes me.

I have a set of values 0 to 99 that I need to append as a two character string to an existing string. I can go through an "if" routine that checks and then functions but it seems like "too much cure for too little sickness".

Isn't there some easy one or two line conversion to take the value 1 and append it to a string as "01"?


Thanks

 

[VoG]

Try like this

=A1&TEXT(B1,"00")

where A1 contains a text string and B1 contains a number.

 

[Fowmy]

Instead of IFs, you may use this TEXT function as below:

=TEXT(a1,"00")

 

[KG Old Wolf]

Thanks you both - I was unaware of the format abilities within the TEXT command... makes so much sense