I want the text in a combo box to always appear in the format 00000 i.e. if the number is 1 then I want it to appear as 00001


I have tried :

cbo1 = format(cbo1.text, "00000")

but it doesn't seem to work

Any suggestions